format uppercase text in bookmark to be in title case

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

HeatherO - 07 Mar 2005 02:19 GMT

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

Reply to this Message

Jezebel - 07 Mar 2005 02:49 GMT

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.

>I have a macro that takes data from an excel spreadsheet and inserts it at
>a
[quoted text clipped - 9 lines]
> TIA,
> Heather

Reply to this Message

HeatherO - 08 Mar 2005 01:21 GMT

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

> 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
[quoted text clipped - 13 lines]
> > TIA,
> > Heather

Reply to this Message