i HAVE in cellS:
A1: J234 TELEPHONE
A2: J23456 WASHER
i WANT THESE TO BECOME:
B1: J234 C1: TELEPHONE
B2: J23456 C2:WASHER
THANKS
i HAVE in cellS:
A1: J234 TELEPHONE
A2: J23456 WASHER
i WANT THESE TO BECOME:
B1: J234 C1: TELEPHONE
B2: J23456 C2:WASHER
THANKS
Use the Text to Columns option.
go to Data > Text to Columns and follow the prompts
Google is your best friend!
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks