Re: Move data to list format

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: sagesearcher (anonymous_at_discussions.microsoft.com)
Date: 05/30/04 

Date: Sun, 30 May 2004 13:51:03 -0700

Thanks to you both! Bob, the formula worked beautifully for cells in the same column. Can you tell me how to adjust the formula to extract the data from the following format. I am knowledgable enough to edit the formula for beginning cell reference. I have extracted company name, address, and city. I need state, zip, and contact name. Thanks!!!!
Client: 1419 StartDate: 11/01/2001 Billing: COMPANY USA
                COMPANY USA Address: ATTENTION: ACCOUNTS PAYABLE
Address: 123 APPLETREE STREET P. O. BOX 12548
                                                                
                                                JACKSONVILLE
                JACKSONVILLE FL 32254 Contact: NORMAN WILDS
Phone: (000)000-000 Phone: (000)000-0000 Fax:
                                                Status:
                () - - PERMANENT
                                                                
                Contact: NORMAN, PHILLIP (904) 693-1354 Title: