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.

Restructure text order
 

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.

Restructure text order
 

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.