You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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
