Cell reference to remove blank value at the end of Number/Text

[dunmore83]

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 ?

 

[Saba Sabaratnam]

You could use TRIM(D15) if it is a space or SUBSTITUTE(D15,"_","") is a under score.

Kind regards

Saba

 

[Momentman]

You can use

=LEFT(D15,LEN(D15)-1)

to have it as TEXT
or

=LEFT(D15,LEN(D15)-1)+0

to have it as numbers