Q:

cut text into excel and preserve cells

I'm writing a program that emails some data to a few of my employee's 
One of them tracks the data in excel so I added a purely data line in text to the bottom of the email so he can just copy and paste it into excel.
I used \t (tabs) to denote fields but when I paste, it all runs together. Is there a character to put in each field in a cell in excel?

A:

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.

