Hi everyone

I currently have a set of data which is all in upper-case text
characters.

Before I can merge the data with another column I need it so that the
first letter of each cell is in upper-case and the rest is in
lower-case.

e.g. I currently have LONDON and I need it to say London

Does anyone know if this is possible within Excel?

Many thanks for your help.

Jon


--
fuzzyjon
------------------------------------------------------------------------
fuzzyjon's Profile: http://www.excelforum.com/member.php...o&userid=34378
View this thread: http://www.excelforum.com/showthread...hreadid=542110