Thread
:
Can I divide a column at the first "space" occurance
View Single Post
#
6
[email protected]
Posts: n/a
Assuming your text is in A1
In B1 enter =LEFT(A1,FIND("&",A1,1)-1) to get jones john
In C1 enter =MID(A1,FIND("&",A1,1),LEN(A1)-FIND("&",A1,1)+1) to get &
Sharon
Ilan
Reply With Quote