is there any way to split text content in a cell and copy it to another
location of cells. for eg:

Cell A1(text format) contains 123456789
and i want to split the content into three parts as 123, 456 & 789 and
copy the three values into b1,C1 & D1 respectively.

can anybody help me?

via135


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=492639