| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sorting an Address List
I have a list of addresses I want to sort. It was exported from a website, so it came into Excel this way: Company Name1 Address1 City, State, Zip1 Phone1 Company Name2 Address2 City, State, Zip2 Phone2 And so on... My goal is to get this list into colums where column A is Name, column B is Address, column C is CityStateZip and ColumnD is Phone. This way I can do a mail merge, or import it into Access. I hope my example makes sense. Thanks for your help. Steve -- steve_g ------------------------------------------------------------------------ steve_g's Profile: http://www.excelforum.com/member.php...o&userid=24410 View this thread: http://www.excelforum.com/showthread...hreadid=380116 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Word address list to Excel | Excel Discussion (Misc queries) | |||
| Address List in Excel | Excel Discussion (Misc queries) | |||
| add email address to a list of names | Excel Discussion (Misc queries) | |||
| loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) | |||
| Loop through email address list to send e-mails | Excel Discussion (Misc queries) | |||
Threaded Mode
