format uppercase text in bookmark to be in title case

[HeatherO]

I have a macro that takes data from an excel spreadsheet and inserts it at a
bookmark, unfortunately the name is in all upper case and the end user wants
the name to print in title case which I believe means with only the first
letter uppercase and the rest lowercase. Is there a format out there that
does this automatically or some way of formatting this data in my macro to do
this? Any help is appreciated, I don't know what I'd do without this message
board.
TIA,
Heather

 

[Jezebel]

Easiest is to fix it in Excel first, using the Proper() function. Then you
can see that it's worked the way you want, and make manual changes if
necessary to deal with oddballs like deVere, ffolkes, n'Khosi, etc.

 

[HeatherO]

That would be the easiest way however I have to not manipulate the data to
much in the excel spreadsheet for "comparison purposes" or something like
that. I might just though try to update it in my macro, since I do my sort
there too, and I guess they don't like that too much either. Thanks for your
help and I think I'll leave the manual changes for the person asking me to do
this stuff.
thanks,
Heather