ExcelBanter - how to alphabetize email addresses on excel spreadsheet?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to alphabetize email addresses on excel spreadsheet? (https://www.excelbanter.com/excel-discussion-misc-queries/247075-how-alphabetize-email-addresses-excel-spreadsheet.html)

ricklin

how to alphabetize email addresses on excel spreadsheet?

have 100+ email addresses randomly placed on spreadsheet. How do I sort these
alphabetically?

dlw

how to alphabetize email addresses on excel spreadsheet?

what do you mean by randomly placed? In order to sort, they all have to be
in one row or column, then you can use a FIND command to select everything
with an @, which would be the addresses, then you sort that.

"ricklin" wrote:

have 100+ email addresses randomly placed on spreadsheet. How do I sort these
alphabetically?

All times are GMT +1. The time now is 05:53 AM.