hi
on the tool bar...
data>text 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
