Degree symbol
 

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

Good afternoon JKB

Highlight the whole range and select Edit Replace.

Find : ° and leave replace blank.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=469884

Thank you for your help. Your solution did the trick.
Ken

"dominicb" wrote:


Good afternoon JKB

Highlight the whole range and select Edit Replace.

Find : ° and leave replace blank.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=469884

Hi Ken

Great stuff. Thanks for the feedback.

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=469884