Gord:

After you do text to columns, can't you just concatenate the two cells (in
reverse, obviously), adding a space in between?

"Gord Dibben" wrote:

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?