Proper Case

[amerifax]

I want to change my Uppercase text to proper.

I found and used the Proper() function. What I am wondering about is when I have a Name such as MCDONALD or O'NEIL. What can I use in cases such as this to convert the text properly?

Thanks,

Bob

 

[Ruddles]

You asked this question at http://www.mrexcel.com/forum/showthread.php?t=552951 and I've posted a suggestion. If you start multiple threads on the same topic, it dilutes the effectiveness of the assistance as you end up with two groups going off in potentially different directions.

 

[Jon von der Heyden]

I'm closing this thread. Please pursue your original thread. Per the forum rules threads od duplicate nature will be deleted or locked.