hi..SCOTTO

i am able to get the result with the MID function. but the thing is, i
want to split one text string into 3 different strings and copy those 3
strings into different cells at one stroke using a formula..! can u help
me?!

regds
via135





ScottO Wrote:
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
|


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