How do I separate address information from within a single column in Excel?
Top Open the Excel spreadsheet and highlight the column in question. To highlight the column, click in the shaded letter column heading box at the top of the column. Select “Data” from the main Excel menu. Select “Text to Columns” from the dropdown box. Depending on how the data is separated (e.g., commas, tabs, spaces) select the appropriate option.
