Address Locator for Geocoding Issue (picture)

Discussion created by samantham on Oct 25, 2012
Latest reply on Oct 29, 2012 by bharold-esristaff
I have a very large dataset of property addresses that I subscribe to. The problem is, the way the  data is currently sorted in excel itcannot be geocoded. The problem is, in the database, it stores the address in a single cell.

For instance "123 main street Denton TX 76205", that is a single cell in the column. Is there a way, either through Excel Macro within ArcGIS or some other method, to quickly go through the database and break apart each of the addresses into additional fields for each entry?

Such as:

"Address" 123 Main Street
"City" Denton
"State" TX
"ZIP" 76205

I will need to break it apart in this manner to geocode the data.