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
 
Back
Top