Im 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.

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.

Ann,
Did you use Text to Columns under Data menu?
If you have to do it repeatedly then you can use a code
else you can adjust it manually.
Cecil

"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.