Data TextToColumns follow the menus will work if your data is all the
same length, or separated by equal separators..........this formula will
give you the number but leaving off the rightmost three characters,
regardless of how many characters there are in the number..........

=MID(A1,1,LEN(A1)-3)

Vaya con Dios,
Chuck, CABGx3



"dan" wrote in message
...
Hi, thaks, but is there a way so it actually *cuts* the data from the
original cell and puts it in the new cell? exp:

a1 123456 and I want to take out 456 and put it in the next column

so it ends up being

a1 123 b1 456



"CLR" wrote:

=RIGHT(A1,3)

Vaya con Disos,
Chuck, CABGx3


"dan" wrote in message
...
I did this a few years ago but have lost the formula.

I have a column of data. I want to take the last three digits of the
data
from the column and put them in their own column. I know there's a
fairly
simple forumla for this, but it's been a long time for me. Any help
would
be
appreciated.