I sure could use some help. I use a program at work which outputs our contact list into Word. However each part (name, address, etc.) is seperated by a ^ and each individual's entry is seperated by multiple ^'s. I've provided an example below (this is actually the header line that it produces, but it's in the same format) I need to get this into excel so that each single ^ is a new cell (column) and each multiple ^ is a new row. Help please! I need to be able to convert it to Excel so that I can compare it with existing records in Excel THANKS A BUNCH!!!
ADDRESS 1^ADDRESS 2^BUSINESS^CITY^CONTACT FIRST NAME^CONTACT LAST NAME^CONTACT SUFFIX^CONTACT TITLE^COUNTRY^INDIVIDUAL NAME^PHONE NUMBER^PHONE/FAX^PHONE/CELL^FORMAL SALUTE^INFORMAL SALUTE^STATE/PROVINCE^ZIP/POSTAL CODE^EMAIL
^^^^^^^^^^^^
ADDRESS 1^ADDRESS 2^BUSINESS^CITY^CONTACT FIRST NAME^CONTACT LAST NAME^CONTACT SUFFIX^CONTACT TITLE^COUNTRY^INDIVIDUAL NAME^PHONE NUMBER^PHONE/FAX^PHONE/CELL^FORMAL SALUTE^INFORMAL SALUTE^STATE/PROVINCE^ZIP/POSTAL CODE^EMAIL
^^^^^^^^^^^^