A program I use exports into Excel. All of the account information is stuck
into one cell and I want a macro to extract this information into separate
cells. This information in Excel looks like (A3, A4 and A5 shown):

ABC Inc. (105920) Denver, CO; SSP AB
Gadgets Inc (315555) New York, NY; SSP AA
Tony Junior (330266) Los Angelas, CA; SSP NA

There will be a minimun of 100 accounts each export. I want to be able to
put the company in Column B, account # in Column C, city in Column D and
discard the rest.

Any advice? Thanks in advance.
Brad K