Changing case
Posted by Jon Hall on October 09, 2001 4:52 AM
Hi,
I have exported a lot of data from an old mini system and am using excel to manipulate it before importing into a new PC base database. The old system stored all data as all uppercase. I need to have excel change the case of cells to initial caps. i.e. I need for fields like lastname to convert JOHNSON to Johnson. I'm sure this is probably a simple problem so please bear with me.
TIA
Jon
Posted by Chris on October 09, 2001 6:02 AM
Jon
3 Functions you need to know:
=upper(text)
=lower(text)
=proper(text)
The proper text is the one you need to use.
Hope this helps.
Chris
