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.