Page History

...

1. In the ‘Delimiters’ box, check Tab and ensure that the column break lines appear in the correct locations in the ‘Data preview’ box, as shown below, and click Next >.
   
   
   
   
2. Click Finish.
3. In the 'Import Data' window, click OK.

You could now delete any unnecessary columns and save this Excel worksheet to map the XY coordinates just like you did in the first exercise.

...

1. On the desktop, double-click the XY folder.
2. Double-click Flower Garden Banks NMS Buoy Locations.xlsx to open the file with Excel.

...

1. Click cell D2 to select it.
2. In the formula bar, highlight the degree symbol (°) and press Ctrl+C to copy it.
   
   Image Added
   
   
3. Click column D to highlight the entire column.
4. At the top of the Excel windowIn the ribbon, click the Data tab.

...

2. Under the Data Tools section, click the Text to Columns button.

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 (°).

...