Split street address into cells

[sammy1]

Hello All. I need a few formulas that will split the below addresses into the following separate cells

1. House number
2. Street Name
3. City Name
4. State
5. Zip code
6. County

The data i receive looks like column A. I need a formula that will produce the right side of my table.
Thanks very much in advance

Source Data		Formula Needed	Formula Needed	Formula Needed	Formula Needed	Formula Needed	Formula Needed
Address	>>>	House Number	Street Name	City	State	Zip	County
4321 Fielding Way Stone Mountain, GA, 30088 Dekalb County	>>>	4321	Field Way	Stone Mountain	GA	30088	Dekalb County
123 Little River Dr Savannah, GA, 31419 Chatham County	>>>	123	Little River Dr	Savannah	GA	31419	Chatham
40 Third St Elko, GA, 31025 Houston County	>>>	40	Third St	Elko	GA	31025	Houston

<tbody>
</tbody>

 

[Rick Rothstein]

I believe i can get a list of all cities in my data set. Is there a way we can find differentiate the street and city name equipped with this new information

If you had such a list, then the space in front of them could be physically changed to a comma/space giving us a delimiter which other code could then use to split apart each address cell.