View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ann Vlna Ann Vlna is offline
external usenet poster
 
Posts: 1
Default Comma delimited text to columns

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.