Extracting parts of a cell
 

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

Extracting parts of a cell
 

Select column A and paste it into column B
select column B and do Data=Text to Columns, select delimited and then left
paren as the delimiter. Finish up

Now select column C and do Data=Text to Columns and select delimited and
right paren as the delimiter. finish up

Now select column D and do Data=Text to Columns and Select comma as the
delimiter. finish up



--
Regards,
Tom Ogilvy



"Brad K." wrote in message
...
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