Separate Full address

[jonbperrier]

I have full addresses in one column; however, they are not all the same. I would like to separate the Street, City, State Abbreviation, & Zip code into separate columns.

I tried text to column but found that the variations from row to row deter this solution.

Desired format represented on second page of attached spreadsheet

[millz]

Unable to load the link. Upload a sample of your workbook directly on this forum instead. This way, people can directly access/work on your data without having to type it off a screenshot.

[jonbperrier]

I attached file

[millz]

So how do you want the address to be separated into? Or is the desired results in the sample workbook and I missed it?

[jonbperrier]

Thanks for the response, please see revised spreadsheet (attached)

[millz]

Try this attached file. Select the cells with the address ( F1:F35 in this sample ) in the worksheet Current Clients and click on the button.

The splitting is done by looking at the "double spaces" inbetween. If your data does not always split by 2 spaces it would not work.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.