Questions? Call us 302-234-9857, 8AM to 10PM U.S. East Coast time 7 days a week
|
||
Questions? Call us 302-234-9857, 8AM to 10PM U.S. East Coast time 7 days a week |
||
|
|
|
|
The Address Assistant for Microsoft Excel helps you split cells containing street addresses, cities, states, and zip codes into multiple columns. It can also recombine such columns (for example just the street addresses) back into a single cell. Another feature can split zip+4 code entries in a cell into separate cells. The following dialog of the Address Assistant shows the many different features that it has:
One very useful feature of the Address Assistant is the feature that adds leading zeros to zip codes. This feature is very useful when one imports addresses into an Excel worksheet and Excel converts zip codes like 02305 to 2305 dropping the leading zero! And if you need to export the zip codes to a CSV file, you may need to add a special space character to prevent leading zeros from being dropped when imported in another program. Another problem the Address Assistant solves is the need to split addresses from one column into multiple columns.
Customers who viewed the Address Assistant also viewed:
|
|
|||||||||||||||||||||||||||||||||||||||
| Copyright 2009 Add-ins.com LLC, all rights reserved. Spreadsheet Assistant is a registered trademark of Add-ins.com LLC. Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. |
