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:
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,
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,