I have a list in excel of first and last names currently in one cell. To import into another program i need them in seperate cells. I know it can be done but just can't remember how.
Please help.
Ian Stacey
Replies (10)
Please login or register to join the discussion.
Simple solution using Word
There are many solutions to this problem. Here is yet another one (or maybe not, I haven't looked through all of the previous answers).
I would simply copy everything and paste it into an empty word document.
Important!: When pasting choose "paste special" and "Unformatted text"
Then do a "find and replace" in Word (press ctrl+h). In the find box simply press the space button one step (or write a comma , ) if the names are separated with a space (or a comma). In the replace box write "^t" (without " "). The press the "replace all"-button. ^t is the sign for tab.
Now copy and paste everything into an excel sheet (preferably a new sheet). This time just paste as you normally do.
Now you will find that names has been separated as you wanted.