Thread
:
Can I divide a column at the first "space" occurance
View Single Post
#
8
jv
Posts: n/a
Thank you so much. That worked for me
JV
" wrote:
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