M
Metfan
I download a file that contains 5,000 rows of data, each cell shows
numeric value, however, you can not use a formula such as @sum to ad
the data as each cell apparently contains an extra space after the las
digit in the cell. When I select a cell and press F2 I noticed th
cursor is 2 spaces behind the last digit, when I hit backspace an
deleted the extra space, the value then changed to a number which I ca
use in a formula. I guess I need to write a macro to the following. G
to each cell and edit and delete the extra space and then proceed to th
next cell and perform the same edit. This needs to be done for al
records. Any help on how to approach this macro would be helpful
Metfa
numeric value, however, you can not use a formula such as @sum to ad
the data as each cell apparently contains an extra space after the las
digit in the cell. When I select a cell and press F2 I noticed th
cursor is 2 spaces behind the last digit, when I hit backspace an
deleted the extra space, the value then changed to a number which I ca
use in a formula. I guess I need to write a macro to the following. G
to each cell and edit and delete the extra space and then proceed to th
next cell and perform the same edit. This needs to be done for al
records. Any help on how to approach this macro would be helpful
Metfa