Hi,
I have a column of data where the numbers are stored as text & the last field in the data is a space.
For example in cell D15 is 00650657_ (where the _ is a space/blank value).
I need a formula to reference cell D15 so it removes the blank value at the end & just returns 00650657.
Any helpers ?
I have a column of data where the numbers are stored as text & the last field in the data is a space.
For example in cell D15 is 00650657_ (where the _ is a space/blank value).
I need a formula to reference cell D15 so it removes the blank value at the end & just returns 00650657.
Any helpers ?