cansevin
asked on
Pull data out of one Column.
Attached we have an excel file with all the data in Column A. I want to seperate this to 5 different columns.
Column B: 1 1st Numeric digit that is always 8 characters long - the 1st 8 characters.
Column C: The first name -always the 1st word
Column D: The Last Name - either the 2nd word or the first word before the parenthesis.
Column E: The parenthesis part
Column F: The date - which is always the last part. List1.xlsx
Column B: 1 1st Numeric digit that is always 8 characters long - the 1st 8 characters.
Column C: The first name -always the 1st word
Column D: The Last Name - either the 2nd word or the first word before the parenthesis.
Column E: The parenthesis part
Column F: The date - which is always the last part. List1.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you! Really appreciate your help!
=REPLACE(A1,1,FIND(CHAR(1)
to take care of the first row.