You can press Finish to see the result of your split out addresses.Ħ. This next page will show you what your list of addresses will look like. If the addresses in your file are separated by commas such as '1 Union Street, San Francisco, CA 94111', you should select Comma as the Delimiter and then press Next.ĥ. On the first page, make sure you select Delimited and then press Next.Ĥ. Let go of Alt, then press E twice.ģ. This will bring up the Convert Text to Columns Wizard. Keyboard Shortcut: Press and hold Alt, and then press A. Mouse and Keyboard: Go into the ribbon at the top of the screen and select Data, and then choose Text to Columns. Keyboard Shortcut: Select any cell from the column that has the address info. Mouse and Keyboard: Click the letter above the column where the address info is, and it'll select the entire column.

The first thing that you need to do is to select the column where the address info is.

You've just found a new list of leads with the addresses in a single column, and you want to split them up so you can use one or more of its components as filters.ġ.

Excel convert mac address format