I currently have a column formatted as text that includes numbers and text. Example
25tn
12.34tn
16.8tn
All of the entries end in "tn" which is what I want to remove. I also then need to format the column as a number.
Thanks