searching a range
 

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.

searching a range
 

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Rich Cooper" schrieb im Newsbeitrag
...
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.