The Community posts I've read say to go to Numbers > Services > split text and use a space delimiter.
I have Numbers 12.1 and there is not split text option. Do you have an update on how to do this?
I have a list of Names and would like to split into 2 columns: First Name and Last Name
If you have a column with the full names, and you are looking to have separate columns for the first and surnames, something like this should work – but it all falls apart if someone has a double-barrelled first or surname (ie. the full name contains more than one space).
First name formula:
TEXTBEFORE(A2," ",)
Surname formula:
TEXTAFTER(A2," ",)
If you have a column with the full names, and you are looking to have separate columns for the first and surnames, something like this should work – but it all falls apart if someone has a double-barrelled first or surname (ie. the full name contains more than one space).
First name formula:
TEXTBEFORE(A2," ",)
Surname formula:
TEXTAFTER(A2," ",)
Thank yo for the swift reply.
Glad to have helped.
How do you split text string into two columns
