You'll need 3 formulas ... one in each "receiving" cell.

Do you want that?

In B1:
=LEFT(A1,3)

In C1:
=MID(A1,4,3)

In D1:
=RIGHT(A1,3)

You can also use TTC, if all your data is as you posted (equal length
strings), which will copy the separated data into 3 contiguous columns with
"one stroke".

Select your column of data, then:

<Data <TextToColumns
Click on "Fixed Width", then <Next,

Click in the "Preview" window and place the break lines where you wish to
separate the data, then <Next,

Click in the "Destination" box and enter the cell where you wish the "copy"
to start, say B1, then <Finish.

Is that what you want?

Anything else will need code.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"via135" wrote in
message ...

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