Text to Columns from the Left

[Jim]

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

 

[Dave R.]

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

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

 

[Jim]

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)&SUBSTITUTE (A1,"*",""),A1)





.