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″
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″
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
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
Probably many ways.
Assuming Row 1 is headers, Full Name, First, Last
Column A contains full names
B2=LEFT($A2,SEARCH(" ",$A2))
C2=RIGHT($A2,LEN($A2)− LEN($B2)+1)
How to fragment a column in Numbers?