Separating

i HAVE in cellS:

A1: J234 TELEPHONE
A2: J23456 WASHER

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

B2: J23456 C2:WASHER

THANKS

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