How to fragment a column in Numbers?
I heve one column with full names and I need to frgmante it to two colums - first name and second name. How do I do it in Numbers?
MacBook Air 13″
Question marked as
A simple way, assuming the full name is in A2 and you always have a first name and last name (but no middle name) is:
In the first of the two columns, say B2:
=TEXTBEFORE(A2," ")
In the second of the two columns, say C2:
=TEXTAFTER(A2," ")
If you sometimes have a middle name then you could try:
=TEXTBEFORE(A5," ",−1)
and,
=TEXTAFTER(A5," ",−1)
The -1 simply says find the last space in the full name.
More on these functions here:
SG
