Help with Selecting Partial Text from a Cel

New Contributor

I have a list of student in the format:  Last, First in the same cell.  I want to copy just the last name into one cell and the first name into another cell but I can't remember how to do this.  I know I can use the comma as the delimiter but can't remember the function.  HELP!

2 Replies


You could use Data > Text to Columns

Specify Delimited, then click Next>.

Select Comma, then click Finish.


Or if you prefer formulas:

Let's say the names are in A2 and down.

The last name is returned by the formula =LEFT(A2,FIND(",",A2)-1)

The first name is returned by the formula =TRIM(MID(A2,FIND(",",A2)+1,100))

These can be filled down.

Thank you so much. I thought Left might be the tool to use but couldn't quite figure it out. I really appreciate this.