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.
Wait for Vog coming on he will advise
Try find and replace from the Edit menuyou have to be quite specific about what to change but it will get the job done
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 rightFunction VoG(r As Range) As StringVoG = StrConv(r, vbProperCase)End FunctionPress ALT + F11 to return your sheet then use the formula=vog(A1)to convert the text in A1.
What would we all do without trusty old VoG™!
Rahere.Thanks that works.Vog's answer may make it simpler!
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.
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
© Copyright 2017 IDG UK. All Rights Reserved.