Hi reader,
Lets find how to split a full name from a Excel column with the example bellow:
Considering the "Full Name", in order to extract the last name we should use the function "=TRIM(RIGHT(SUBSTITUTE(FullName;" ";REPT(" ";100));100))" where:
Hope it makes your spreadsheets easier.
Lets find how to split a full name from a Excel column with the example bellow:
Considering the "Full Name", in order to extract the last name we should use the function "=TRIM(RIGHT(SUBSTITUTE(FullName;" ";REPT(" ";100));100))" where:
- FullName: full name to separate (e.g. cell A2)
If you want to separate the first name, just replace "RIGHT" for "LEFT" in the function above.
Hope it makes your spreadsheets easier.
Comments
Post a Comment