How to remove the last letter from a text field.


I have a list of data:

8888 H

88 H

888 M

8.888 M

How do I remove the H & M to leave a number that I can use in a calculation?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!