select column A (columns B to D should be blank)

do data = text to columns and in the wizard choose delimited and then
select the comma as delimiter on the next dialog.

--
Regards,
Tom Ogilvy

"Ann Vlna" <Ann wrote in message
...
I'm not a programmer so can someone help me with code for the problem
listed below.

I have a column of addresses in Excel. Example of original column is:

Column A
Street address, suite no., city, state zip
Street address, city, state zip

I need to start at the right and extract the data up to the first comma
and second comma (individually) into their own columns. Then I need it
deleted from the original column. I start with one column and end up with
three columns. Examples of new columns a

Column A Column B Column C
Street address, suite no. city state zip
Street address city state zip

Thanks in advance.