Excel question

  rawsongreen 12:13 23 Feb 10
Locked

Is it possible to change the first letter of words to uppercase without changing the letter after an apostrophy as well, as using ‘=proper’ does.
Or is there a way of changing letters after an apostrophy to lowercase.

  folsom 12:20 23 Feb 10

Wait for Vog coming on he will advise

  Rahere 12:24 23 Feb 10

Try find and replace from the Edit menu

you have to be quite specific about what to change but it will get the job done

  VoG II 12:29 23 Feb 10

With a User Defined Function: Press ALT + F11 to open the Visual Basic Editor, select Module from the Insert menu and paste into the white space on the right



Function VoG(r As Range) As String
VoG = StrConv(r, vbProperCase)
End Function


Press ALT + F11 to return your sheet then use the formula

=vog(A1)

to convert the text in A1.

  shellship 12:39 23 Feb 10

What would we all do without trusty old VoG™!

  rawsongreen 12:42 23 Feb 10

Rahere.

Thanks that works.

Vog's answer may make it simpler!

  rawsongreen 13:02 23 Feb 10

Vog.

What can I say that has not been said probably hundreds of times before.

Thank you.

This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

How VR is being used to simulate space

New iPad, iPhone SE & Red iPhone 7 on sale now