This is worksheet.functions.. so if you want a formula solution, you can
try:

=IF(ISNUMBER(FIND("*",A1)),REPT("*",9)&SUBSTITUTE( 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