I have a 15,000 line spreadsheet where the addresses are listed with the street address then unit number then city then state code and zip separated by spaces within a single cell. A1 Example:
<colgroup><col></colgroup><tbody>
</tbody><strike></strike>
After trying myself I have adding all states listed by two letter state abbreviation in column I starting a row A, if that is helpful in anyway. If not, I can obviously deleted column.
I would so appreciate any help getting this split.
23 NW 27th Lane Cape Coral FL 33993 I need the address to split like so:
<tbody> </tbody> |
<colgroup><col></colgroup><tbody>
</tbody>
After trying myself I have adding all states listed by two letter state abbreviation in column I starting a row A, if that is helpful in anyway. If not, I can obviously deleted column.
I would so appreciate any help getting this split.
All searches are showing how to do it when there is a comma following street address and another following city. PLEASE HELP!