So, I'm working on a dataset which involved downloading track data from a gps and pasting the results into excel. I am having trouble with the "heading" column. The column gives a value, followed by a degree symbol. I need to get rid of the degree symbol in the entire column, but I don't want to have to do it manually, and so far I have not been able to do this using the formatting tool, or the find and replace tool. Any suggestions?
Kate
Bookmarks