View Single Post
  #8   Report Post  
jv
 
Posts: n/a
Default

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