Restructure text order

I have a worksheet in which the names are in this order: Last, First. I want
to use this as a mailing list and need to have the names in the more normal
order of: First Last. Is there a function to do this? I don't want to have
to edit each cell.

Look at Data==>Text to Columns

"Edward" wrote:

> I have a worksheet in which the names are in this order: Last, First. I want
> to use this as a mailing list and need to have the names in the more normal
> order of: First Last. Is there a function to do this? I don't want to have
> to edit each cell.
>

Worked like a charm. I owe you!

"Toppers" wrote:

> Look at Data==>Text to Columns
>
> "Edward" wrote:
>
> > I have a worksheet in which the names are in this order: Last, First. I want
> > to use this as a mailing list and need to have the names in the more normal
> > order of: First Last. Is there a function to do this? I don't want to have
> > to edit each cell.
> >