Help with deleting a degree symbol from a column

**KateL** · 01-28-2009, 01:08 PM

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

**DonkeyOte** · 01-28-2009, 01:22 PM

You could try the following:

Please Login or Register  to view this content.

Any joy ?

**shg** · 01-28-2009, 01:23 PM

Welcome to the forum.

Select the column, do Edit > Replace, in the find what box, do this:

Hold down the Alt key, and on the numeric keypad, type 0176. The degree symbol will appear.

Replace All.

**erickzind** · 09-28-2019, 05:29 PM

Originally Posted by shg

Welcome to the forum.

Select the column, do Edit > Replace, in the find what box, do this:

Hold down the Alt key, and on the numeric keypad, type 0176. The degree symbol will appear.

Replace All.

I did exactly what he said and I solved my problem.