searching a range

R

Rich Cooper

this is similar to my previous question. I have a range of names. I want
to search it for a space and put the part before the space in a new range
and everything after the space in a range right next to the one containing
the first part. I have tried the search function but i can not get it to
work. Please Help.
 
F

Frank Kabel

Hi
a formula solution:
B1:
=LEFT(A1,FIND(" ",A1)-1)

C1:
=MID(A1,FIND(" ",A1)+1,255)
 
Top