Referencing a value in a cell that contains other text

[isly168]

I would like to reference a numerical value that has a letter on the end of it. For example, the cell will contain the text "2.5x" or "4.5a" and I would like to use just the 2.5 or 4.5 in formulas in other cells. How can I do this?

[Fluff13]

How about
=LEFT(A2,LEN(A2)-1)+0

[isly168]

All the values are 3 characters, the =LEFT(A2,3) works for my purposes. Thanks!

[Fluff13]

You're welcome & thanks for the feedback