Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how to alphabetize email addresses on excel spreadsheet?

have 100+ email addresses randomly placed on spreadsheet. How do I sort these
alphabetically?
  #2   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to alphabetize a column with email addresses? JB Excel Discussion (Misc queries) 1 October 27th 07 05:18 PM
Email addresses in Excel need to format for mass email Boomer Excel Worksheet Functions 1 June 9th 06 01:46 PM
Transfer Email addresses from spreadsheet to email address book Beana Excel Discussion (Misc queries) 2 May 30th 06 06:07 PM
Email Addresses in a spreadsheet NSK Excel Worksheet Functions 2 March 13th 06 04:31 AM


All times are GMT +1. The time now is 01:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"