hi
on the tool bar...
datatext to columns.
follow the wizard. caution.... this deletes data to the right when the cell
is split

you can also use formulas.
cell A1 has the word "text in it.
in cell B1...
=right(a1,2) will return "xt"
in cell C1...
=left(a1,2) will return "te"
in cell D1...
=mid(A1.2,2) will return "ex"

regards
FSt1

"wsijbesma" wrote:


Can anyone help me?


--
wsijbesma
------------------------------------------------------------------------
wsijbesma's Profile: http://www.excelforum.com/member.php...o&userid=35063
View this thread: http://www.excelforum.com/showthread...hreadid=548078