Apple launches Apple Store app in India
The Apple Store app provides customers with the most personalized way to shop for Apple’s innovative lineup of products and services. Learn more >
The Apple Store app provides customers with the most personalized way to shop for Apple’s innovative lineup of products and services. Learn more >
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.
I have first and last names in 1 column and would like to separate them into 2 columns
MacBook Pro 15″, macOS 12.7
Hi SG,
SGIII wrote:
In B2 =TEXTBEFORE(A2," ")
In B3 =TEXTAFTER(A2," ")
Just a thought, I think this is what you meant.
In B2 =TEXTBEFORE(A2," ")
In C2 =TEXTAFTER(A2," ")
No worries, mate!
Regards,
Ian.
If you only have first names and last names (no middle names) then a simple way is to use TEXTBEFORE and TEXTAFTER, something like this:
In B2 =TEXTBEFORE(A2," ")
In B3 =TEXTAFTER(A2," ")
There is also a TEXTBETWEEN function if you have middle names.
There are also ways using REGEX.EXTRACT but the above functions handle most cases.
SG
Hi Ian,
Thanks for the correction!
SG
split first name and last name into 2 columns
