Shannon
You may find it is better to have the names in separate cells rather than change
to first, last in one cell.
Most third-party apps prefer it this way.
You could use DataText to Columns space delimited to split into two cells.
If you want to swap in-cell, see Chip Pearson's site for formulas.
http://www.cpearson.com/excel/FirstLast.htm
Gord Dibben MS Excel MVP
On Sat, 24 Jun 2006 09:14:01 -0700, Shannon
wrote:
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?