Separating information in cell

[Guest]

I am using Excel 2003 SP2. I receive reports with first and last names
together in one cell:

Jones,Edward
Smith, David
Longview,Samantha

Is there a way to move the first name to the same row in the next column,
then remove the comma following the last name?

 

[T. Valko]

With your names in column A, make sure column B is empty so it will accept
the first names.

Select the range of cells in column A that contain the names
Goto the menu Data>Text to Columns
Select Delimited>Next
Select Comma>Finish

This will move the first names and remove the commas at the same time.

 

[Bernard Liengme]

Chip has lots to help you at
http://www.cpearson.com/excel/FirstLast.htm
for more examples do a Google with search term: Excel last name first name.
I got nearly 2 million hits
Hope you do not think this a lazy answer but why reinvent the wheel?
best wishes

 

[Guest]

Oh, joy - hurray for easy solutions - thank you!!

 

[Guest]

Wonderful - thank you! Sometimes I really do love the Internet...

 

[T. Valko]

You're welcome. Thanks for the feedback!