Extract text and numbers

[knaimi]

When I run the Excel failures report for my school, I get the data in the following format:

Last name, First name (student id #) So I tried to use a function to separate them into three cells based on the following format: Student ID # Last name First name. Please see example below:

Student	ID	Last	First
Smith, John (123456)	123456	Smith	John

I used =MID(A2,FIND("(",A2)+1,FIND(")",a2)-FIND("(",A2)-1) to extract the student ID
I used =LEFT(A2,(FIND(", ",A2,1)-1)) to extract the last name
I was not able to find a suitable formula to extract the first name.

I hope you can help with this request.

Thanks,

 

[Joe4]

Here is one way:

=TRIM(MID(A2,FIND(",",A2)+1,FIND("(",A2)-FIND(",",A2)-1))

 

[knaimi]

Thanks, Joe4

 

[Joe4]

You are welcome.