Mixed Case Question

  • Thread starter Thread starter kbreenbo
  • Start date Start date
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!
 
Back
Top