Separating information in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combining multiple columns using ", " seperations.. 4
Need to alphabetize data from separate cells within same row 2
Vlookup for a max value ? 4
Separate First Name MI and Last Name into three Cells 3
Pivot Tables: Excel 2003 vs Excel 2007 2
parsing a full name out into Last, First, Middle 2
Moving data from multiple rows to single rows 5
breaking a field out 2

Back
Top