All Caps to Proper Case

[amerifax]

Does anyone out there having a solution for working with a name field. I have to convert all caps to proper. I have many of the typical problems associated with names. Here are a few:

Mc, Mac, Jr, I, II, one initial, two initial, LA, O'

There are so many I'm kind of drawing a blank tonight but I think you get the idea. This is how the data looks.

WALDORF ROBERT & VICKIE
ELKINS C
VETTER M M
FERBER-STUMPF JANELLE

It's a big project, but I was is hoping that maybe somebody has already done this dance and has it available.

 

[amerifax]

Abgar - I don't physically see where McDonald's or II is stated in the cold. I use Dragon to do my typing for me as I'm doing right now. and McDonald's was type in perfect with no interaction from me. So it stands to reason it can be done. you're using a dim,as I call it, to accomplish the task. I pray the day that I'll be able to use something like this dim which must be a variable. It will be taken me to a new level which I need to be on.

I use variables all day long with a program called MacroExpress Pro with no problem. Tomorrow I am going to look into this code the same as I will be doing with the one above and try to get my feet wet without drowning.

Bob

 

[willcass]

willcass

I will upload the completed file when done. Also do you have a list on the problem name, such as Mc, O' and so many more.

Sorry I don't unfortunately - its a case of looking at the data and seeing where any problematic text strings are.

I also found this useful thread you might find of interest:

http://www.mrexcel.com/forum/showthread.php?t=83430

Good luck