View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
wjohnson
 
Posts: n/a
Default coma not separating data


Are you Copying and Pasteing?
or Are You doing a "FILE OPEN?"
If you are doing a File Open then EXCEL should interpert the file as
comma separated values, (CSV) and put stuff into different columns.
Copy and paste - everything will go into one column.
But you can also do the following:
Once you have imported the DATA into your EXCEL file - select the
column - then on the MENU Bar - Select - DATA-TEXT TO COLUMNS and
follow the directions.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=526923