I have a spreadsheet in Excel 2003 that includes a column of names in
"LastName, FirstName" format. I need for it to be in "FirstName
LastName" order. How can I do that without manually typing all 300 names?

Text to Columns?
Do you only have 2 names for each person?

Recombine the names in the order after you swap the columns:

use
=A2&B2&C2 ... etc where A2 is the first name and the others the rest.


Regards
Robert McCurdy

"mcp6453" <(E-Mail Removed)> wrote in message news:e$(E-Mail Removed)...
>I have a spreadsheet in Excel 2003 that includes a column of names in
> "LastName, FirstName" format. I need for it to be in "FirstName
> LastName" order. How can I do that without manually typing all 300 names?

Try this:

A1 = LastName, FirstName

=MID(A1&" "&A1,FIND(",",A1)+2,LEN(A1)-1)

result = FirstName LastName

--
Biff
Microsoft Excel MVP


"mcp6453" <(E-Mail Removed)> wrote in message
news:e$(E-Mail Removed)...
>I have a spreadsheet in Excel 2003 that includes a column of names in
>"LastName, FirstName" format. I need for it to be in "FirstName LastName"
>order. How can I do that without manually typing all 300 names?

mcp6453 <(E-Mail Removed)> wrote in news:e$7cAQlMJHA.5428
@TK2MSFTNGP02.phx.gbl:

> I have a spreadsheet in Excel 2003 that includes a column of names in
> "LastName, FirstName" format. I need for it to be in "FirstName
> LastName" order. How can I do that without manually typing all 300 names?
>


The FIND() will give you a location to split the string at the comma:

=LEFT(A1,FIND(",",A1)-1) & RIGHT(A1,LEN(A1)-FIND(",",A1))