3 Answers
3

You can use anything you want that doesn't appear in your data. A popular choice is either "," or "|". When you paste in your data there should be a little box that appears in the lower right of what you just pasted, and you can use that to modify how the data was imported, otherwise you can just use Data-> Text to columns. Then select deliminator, then type in the deliminator you want to use.

not exactly what i wanted but tab's dont seem to work in the email im sending (it replaced with 5 spaces) so i went with | and this combined with the text to column that you showed me finished the project.
–
Crash893Aug 27 '10 at 13:48

As long as you use the same character in between each word (even a space) and then using the text to columns option in excel, then excel will automatically take those texts and convert them to a column, or separate cell:

"This is a test" will convert each word to a cell.

"This:is:a:test" will also, but you have to tell excel that the symbol is the colon.