K
kbreenbo
I've used the =proper formula to convert an entire spreadsheet that was
in uppercase to mixed case. It works fine for all the first and last
names, but when there's a MCINTOSH it naturally becomes Mcintosh
MACDONALD becomes Macdonald. There are too many to change manually.
How does one go about changing this. If in a macro, can someone
provide me with an example or any other option? Thank you!
in uppercase to mixed case. It works fine for all the first and last
names, but when there's a MCINTOSH it naturally becomes Mcintosh
MACDONALD becomes Macdonald. There are too many to change manually.
How does one go about changing this. If in a macro, can someone
provide me with an example or any other option? Thank you!