Thanks !!! You are the man !!!
-----Original Message-----
This is worksheet.functions.. so if you want a formula
solution, you can
try:

=IF(ISNUMBER(FIND("*",A1)),REPT("*",9)&SUBSTITU TE
(A1,"*",""),A1)


"Jim" wrote in message
...
I have a column that has the following:

***************025
25

I need to reduce the column width, but I need to keep
the
numbers and 9 stars. When I use text to columns, it
wants
to seperate the records with stars from the records with
just numbers. Any idea's?

Thanks Guys !!
Jim


.