Can you cut that column and paste to a new worksheet then run EditReplace on
it?

Then paste back into original spot.


Gord Dibben MS Excel MVP

On Tue, 7 Jun 2011 19:33:43 -0700 (PDT), Ty wrote:

I need to remove 3 to 4 decimals in a cells in one column. I know it
has something to do with LEFT and something else. Here is the
example:

7.1.2.5 need to convert it to 7125

Thanks.....