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


"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Cynthia" wrote in message
...
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?
--
Cynthia