Degree symbol

G

Guest

I have a worksheet with latitude and longitude in two columns. Over 1000
coordinates make up the wks. The cell format is xx xx.xxx with the degree
symbol after the first two digits. I would like to remove this symbol from
every cell. How can I do this in one shot? Thanks.
Ken
 
D

dominicb

Good afternoon JKB

Highlight the whole range and select Edit > Replace.

Find : ° and leave replace blank.

HTH

Dominic
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert decimal degree (lattitude/longitude) into Degree, 5
Temperature (degree) symbol 2
Custom Format 3
Formating Longitude and Latitude 2
degree symbol 7
What is blue symbol bottom right corner of cell 2
How do I insert the degree symbol in a column of numbers? 3
Adding degree (°) symbol after numbers. 4

Top