Page History

...

1. Click cell D2 to select it.
2. In the formula bar, highlight the degree symbol (°) and press Ctrl+C to copy it.
   
   
   
   
3. Click column D to highlight the entire column.
4. In the ribbon, click the Data tab.
5. Under the Data Tools section, click the Text to Columns button.
   

...

1. 
   Image Added
   

1. In the ‘Convert Text to Columns Wizard’, ensure that Delimited is selected and click Next >.
2. In the ‘Delimiters’ box, uncheck Tab and check Other:.
3. Click the text box to the right of Other: to locate your cursor there and press Ctrl+V to paste the degree symbol (°).

...