Removing Text from numbers

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

kdeal,

Select the range say A1:A3 for your sample data. Click Ctrl+H. Put in "tn" in the Find option and nothing in the Replace with option. Click replace all. This will remove the "tn" from the data. To then convert to a number type a 1 in a blank cell. Copy the 1. Select your range again and go to Paste Special and select Multiply. This will convert to numbers.

HTH

Steve

Hi,

Or you could try a helper cell. E.g Data in Col A starting at A1 then enter this in B1 and drag down

=SUBSTITUTE(TRIM(A1),"tn","")

VBA Noob