Split a column value into two columns

  • Thread starter Thread starter trjdba
  • Start date Start date
T

trjdba

Hi all! I have a column name Name. What I'm trying to do is separet
the concatenated field into two diff. fields (LastName and FirstName)


Example: Doe, Jane

I would like to leave Doe in the current column and place Jane in a ne
column to the left of that column.

Hope that makes sense.

All help is appreciated!

TR
 
Use Data | Text to Columns, with a comma defined as the delimiter.

Hope this helps.

Pete
 
This method appears to do the job, but will leave a leading space in front
of Jane, unless both "space" and "comma" are used as delimiters.....

Vaya con Dios,
Chuck, CABGx3
 
Keeping within your two columns.....assuming Doe, Jane is in B1......
In A1 put this and copy down....
=MID(B1,FIND(",",B1,1)+2,99)
Then do Copy > PasteSpecial > values on column A
Then highlight column B and do Edit > Replace > FindWhat: ,* > ReplaceWith:
leave empty > ReplaceAll

Vaya con Dios,
Chuck, CABGx3
 

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

Separating First Name(s) and Last Name into Separate Columns 3
Separating names in a column 3
Text parsing 3
Split LastName, First Name column into 2 seperate columns 9
Split Names 2
Group List by Values in Column A and combine related row values inColumn B into 1 Cell 7
Excel Split column data 0
Add cells in a column where other cells equal a value 3

Back
Top