On Thu, 22 Jun 2006 11:33:09 -0500, T De Villiers wrote:

i HAVE in cellS:

A1: J234 TELEPHONE
A2: J23456 WASHER

i WANT THESE TO BECOME:
B1: J234 C1: TELEPHONE

B2: J23456 C2:WASHER

THANKS

Formula in B1 should be:
=IF(FIND(" ";A1;1)0;LEFT(A1;FIND(" ";A1;1)-1);A1)

Formula in C1 should be:
=IF(FIND(" ";A1;1)0;RIGHT(A1;LEN(A1)-FIND(" ";A1;1));"")

--
PL