First step Open the table you want to extract .
The second step Input left function .
The third step Select the name you want to extract , Take the last name as the first , choice 1.
Step four It's easy to get results .
Expand ,left Function formulas can be used to extract the first value in a cell .
Have you learned ？