View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cynthia Cynthia is offline
external usenet poster
 
Posts: 86
Default Separating information in cell

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