using CSV to break up text into multiple columns

Giganews Newsgroups
Subject: using CSV to break up text into multiple columns
Posted by:  Deena at DCH FD
Date: Wed, 28 Jun 2006

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!

Replies