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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks