Oct 21 2021 01:26 PM
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!
Oct 21 2021 01:43 PM
SolutionYou 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.
Oct 21 2021 01:46 PM
Oct 21 2021 01:43 PM
SolutionYou 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.