View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Deena at DCH FD
 
Posts: n/a
Default using CSV to break up text into multiple columns

I have an excel spreadsheet with first and last name in the same column.
ie:smith,jon. I need to have the last name in one column and the first name
in the next.

How can use .csv to break this into 2 separate columns: cell a1=smith, cell
b1=jon

(I don't know anything about using 'comma separated values' so any detail
info would be greatly apprecaited!