Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Copy/Paste Techniques?
Hi, I'm trying to make my "secretarial" work a bit easier. We have downloaded thousands of company profiles into our database. The company name, company CEO, stock, etc, all managed to come into excel as separate columns, thus easily workable information. However, the address of the companies all came in one colum. For example, these are all contained in their own cells. *company *micro *stock *msft *money *yes *address *1000 money way suite money money seattle, washington, $$$$$ USA 800-100-1000 800-100-1001 however, the address contains too much information what I need to do is get all that address information into separate columns, such as address 1, address 2 (for floor, suite, etc), city, state zip code, phone number, fax number... how do i go about doing this? do i need a macro that will enter the cells? i'm not quite proficient enough in VBA to produce a macro that will be able to target correctly what i need. thanks -- efang001 ------------------------------------------------------------------------ efang001's Profile: http://www.excelforum.com/member.php...o&userid=31552 View this thread: http://www.excelforum.com/showthread...hreadid=512463 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced filtering on text and blanks | Excel Discussion (Misc queries) | |||
Copy/Paste in Autofilter | Excel Discussion (Misc queries) | |||
Advanced on-line Excel course | Excel Discussion (Misc queries) | |||
Advanced Filter Defaults | Excel Discussion (Misc queries) | |||
Advanced Find Command?? | Excel Discussion (Misc queries) |