| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADDRESS MACRO
i have a list of data. all the info is in column a. some info has three
lines some four, some may have more. i need a macro of some sort that would take all of the data and put it into separate colums. an example is this: name of company 23 Gates Ave somewhere, ny 11522 516-xxx-xxxx accounting Ruthizer Scott Cpa 30 Gates Ave somewhere, ny 11552 212-xxx-xxxx NEEDS TO LOOK LIKE THIS name of company 23 Gates Ave somewhere, ny 11522 516-xxx-xxxx Ruthizer Scott Cpa 30 Gates Ave somewhere, ny 11552 212-xxx-xxxx OBVIOUSLY WITH THE LAST COLUMN IN THERE AS WELL. CITY STATE AND ZIP CAN BE ALL IN ONE COLUMN. PLEASE HELP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I put an email address in a macro ? | New Users to Excel | |||
| Address of workbook in a macro | Excel Discussion (Misc queries) | |||
| Change IP address with macro | Excel Programming | |||
| Need a macro to Identify a users IP address | Excel Programming | |||
| Help Pls re macro cell address | Excel Discussion (Misc queries) | |||
![JOSEPH WEBER[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
