Try using this from the menu:
Data - Text to columns
Fixed width - and then pull the line into the middle of johnsmith before you
continue. It will separate into 2 colums etc.
"ibere" skrev i melding
...
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