reformat a cell from last name, first to first space last?

Giganews Newsgroups
Subject: reformat a cell from last name, first to first space last?
Posted by:  shannon
Date: Sat, 24 Jun 2006

I downloaded a spreadsheet with a column in it containing peoples names.
They are listed with the last name first then a comma and the first name or
first initial.  I want to change them to first name and last name sparated by
a space for data base purposes to use in a mailing.  Is there any easy way to
do this?

Replies