Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing the case of text data
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert numbers to text | Excel Discussion (Misc queries) | |||
How to .. | Excel Discussion (Misc queries) | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |