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


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=554645

Separating
 

Use the Text to Columns option.

go to Data Text to Columns and follow the prompts


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=554645

Separating
 

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