Text to Columns from the Left
 

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

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

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


.