Excel question

  rawsongreen 12:13 23 Feb 2010
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 2010

Wait for Vog coming on he will advise

  Rahere 12:24 23 Feb 2010

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 2010

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 2010

What would we all do without trusty old VoG™!

  rawsongreen 12:42 23 Feb 2010

Rahere.

Thanks that works.

Vog's answer may make it simpler!

  rawsongreen 13:02 23 Feb 2010

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.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017