Im not a programmer so can someone help me with code for the problem listed below. Text to Columns doesnt work because some cells have data separated by three commas and others only two commas.

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 (but not the third comma), individually into their own columns. I start with one column and end up with three columns. The problem I have is that there is sometimes an extra comma because some have addresses and suite no. and others just have address.

Examples of new columns a

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

If I use the text to columns some records have four columns and some three. So they don't fall in the correct column and have to be moved around. Also, if there is an address and suite no. they have to be put back together.

Thanks in advance.