| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating words in a single cell
Hello there. This is my first post here, I hope this question is not too stupid, but I have no idea on how to do it...: I have a list of names like this: JOHNSMITH and I need to turn it into this: JOHN SMITH Is there a way to do it? I imagine the way is to ask Excel to include a space between the capital letters, but I don't know how to do it. Thanks! -- ibere ------------------------------------------------------------------------ ibere's Profile: http://www.excelforum.com/member.php...o&userid=35455 View this thread: http://www.excelforum.com/showthread...hreadid=552319 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| How to copy single cell into cell that is merged from two cells? | Excel Discussion (Misc queries) | |||
| How Do? Take two words in cell 1 and slpit them to cell 2 & 3 | Excel Discussion (Misc queries) | |||
| Help creating single cell Pop-up | Excel Worksheet Functions | |||
| Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
Threaded Mode
