Change Case for Names
Try:
=Proper(a1)
Mike
"Jeff" wrote:
I have a data dump with names. Since the users inputs their name, the case
of the name varies. I would like to clean the names up to make them look
nice. For example, the names are typically one of these three:
Jeff (this is good)
jeff (not good)
JEFF (not good)
How can I clean them up so the first letter is always capital and the rest
are lower case?
I hope I can do this.. Thanks!
--
Jeff
|