Hi All
I have an issue with stastistcs id, looking formula or vba to make number to 8 digits as below.
However, after four digits(always) there are trailing space of 1 or 2 or 1 . spaces
the digits will be always 8 numbers , no alphabetical words.
There are eratic blank rows of 1 or 2 or 3 or 4 or more . but should not alter the blank rows
the list goes to 20000 rows of data
Any assistance would be grateful
Sample
4016.991
4016 .991
4016 991
4016 991
4016
should read 4016991
Data header 1
<tbody>
</tbody>
I have an issue with stastistcs id, looking formula or vba to make number to 8 digits as below.
However, after four digits(always) there are trailing space of 1 or 2 or 1 . spaces
the digits will be always 8 numbers , no alphabetical words.
There are eratic blank rows of 1 or 2 or 3 or 4 or more . but should not alter the blank rows
the list goes to 20000 rows of data
Any assistance would be grateful
Sample
4016.991
4016 .991
4016 991
4016 991
4016
should read 4016991
Data header 1
ht code | Expected results |
4016.93 | 40169300 |
4016.94 | 40169400 |
4016.95 | 40169500 |
4016 991 | 40169900 |
4016 999 | 40170000 |
4017.00 | 40170000 |
4101 .2 | 41012000 |
4101.50 | 41015000 |
4101.90 | 41019000 |
4017. | 40170000 |
<tbody>
</tbody>
Last edited: