#1
|
|||
|
|||
I need help with sorting address
I need help to rearrange a download for names. I have over a 1000 rows of information to rearrange.
example first word below in each row is the last name these names need to be in proper order first middle last HAND KATHLEEN ABRAMSON ROBERT & ABRAMSON BARBARA N BENVENUTO ROBERT E & BENVENUTO LOUISE MCTIGHE JAMES M & MCTIGHE CAROLYN A YOUNG SUSAN M BARAZZOTTO CAROLE L PENNINGTON JAMES R & PENNINGTON MALINDA T MCCAUGHAN BOB & MCCAUGHAN LILLIAN WHARTON NANCI K ARMISTEAD W GORDON JR & ARMISTEAD NINA W |
#2
|
|||
|
|||
Looks like a lot of work with the concat() function and vlook()
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Differentiate between my address and my address in a Distribution List | fogyreef | Outlook | 1 | 01-14-2016 12:45 AM |
Add link to email address that hides the actual address or makes it inaccessible to online bots | richiebabes | Word | 1 | 09-03-2014 03:22 PM |
How to forward all e-mails from one address to five (5) other e-mail address? | adi2012 | Outlook | 1 | 09-09-2012 06:41 PM |
HELP! Outlook 2003 Address Books - multiple account address lists | ukmonkeynuts | Outlook | 0 | 06-01-2011 06:18 AM |
Default Home Address over Business Address | DunnDeal | Outlook | 1 | 12-03-2010 04:56 PM |