Hi
I have been trying, unsuccessfully, to remove trailing spaces from a set of numbers (all are 10 Characters) whilst keeping any spaces that may exist in the middle.
TRIM does not work because some of the numbers have 2 spaces in the middle and the TRIM function removes one of these.
I would be very grateful if someone could provide a solution.
Thanks in advance.
example of number set below:
<tbody>
</tbody><colgroup><col></colgroup>
I have been trying, unsuccessfully, to remove trailing spaces from a set of numbers (all are 10 Characters) whilst keeping any spaces that may exist in the middle.
TRIM does not work because some of the numbers have 2 spaces in the middle and the TRIM function removes one of these.
I would be very grateful if someone could provide a solution.
Thanks in advance.
example of number set below:
03685 |
040710 |
089284632 |
0893221 |
0893870004 |
089947002 |
03685 12 |
03685 14 |
0124 5 |
0124 6 |
<tbody>
</tbody><colgroup><col></colgroup>