Assume the following list of addresses are all in separate cells of a single column (A1-A4). I just need the formula to extract the street addresses, and then a separate formula to extract the zip codes.
5430-44 PASCHALL AVENUE PHILADELPHIA, PA 19143 OPA/BRT#: 884350845 4010 MARPLE STREET PHILADELPHIA, PA 19136 OPA/BRT#: 651087200 2618 SOUTH HOWARD STREET PHILADELPHIA, PA 19148 OPA/BRT#: 391251216 5737 WOODCREST AVENUE PHILADELPHIA, PA 19131 OPA/BRT#: 522155600
Bookmarks