| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| € (euro) symbol in Excel charts | Charts and Charting in Excel | |||
| Convert decimal degree (lattitude/longitude) into Degree, | Excel Discussion (Misc queries) | |||
| The Mathematical "Implies" symbol | Excel Discussion (Misc queries) | |||
| How do I insert the degree symbol in a column of numbers? | Excel Discussion (Misc queries) | |||
| Excel should have the same Insert Symbol feature as Word. | Excel Discussion (Misc queries) | |||
Linear Mode
