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