Have you tried the MID function? It should be able to give you what
you want.
Rgds,
ScottO

"via135" wrote
in message
...
|
| 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
|