I am struggling to concatenate: Smith, John into John Smith.
Using this formula
=CONCATENATE(MID(A1,FIND(" ",A1,1)+1,20), LEFT(A1,FIND(",",A1,1)-1))
I get johnsmith and not john smith
Can someone please help very urgently - Thanks.
gah. beaten.![]()
how about one cell: =LEFT(A1,FIND(",",A1,1)-1)
and other cell: =MID(A1,FIND(" ",A1,1)+1,20)
if you could do that concatenation formula the rest is easy!