I'm hoping to find someone willing to help with this problem:



I have an Excel file with several thousand records that are in the following format (this represents the contents of a single cell):

System Acct: 123456 Name: 10 FRIENDS OF MONKEYS Credit Limit: 5.00
BusSys Acct: 123456 Address1: 534 SW WEST AVENUE STE 3 Balance: 5.00
Rate Code: P01L Address2: Aging Bucket: 0
City: YORKTOWN Cus Grp: PT Personal Transient
ST/Zip: OR, 97777 Assigned Sales: 999 Unassigned Salesperson
Phone: 530-947-1000 Tear#: 0 Proof#: 0 Aff#: 0
Notes:

What I need to accomplish is to extract the "Name", "Address1", "City", "ST/Zip" and "Phone" into another unique cell or set of cells.

I spent some time poking around the web and found a way, using "FIND" and "MID", to extract each one separately but I don't know how to combine all of the functions and have the results end up in a separate single cell (we want to create a "call list" or mailing list from the results). Here's what I used to get the "Address1" value:

=MID(A11,FIND("Address1:",A11)+10,FIND("Balance:", A11,FIND("Address1:",A11)+1)-46-FIND(" ",A11))

Anyone go ta slick way to accomplish the above? Many thanks for anyone willing to lend a mind