Hi,
I have a cell that contains a number that is text.
It has leading zeroes and a space after the last digit.
"0011277370 "
I would like to convert this to a number without the leading zeroes and the trailing space.
There may be more, less or no leading zeroes in the numbers and may or may not have a trailing space.
If a number has no leading zeroes and no trailing space then it should remain untouched.
Bookmarks