Separating physical from mailing address

In a customer file I have mailing addresses and street addresses mixed in Column A. Is there a function entered in an adjacent column B that would "look" for the text PO Box and write the complete PO address information in that cell? My goal is to have a column of only street address and a column of mailing address data. Thank you. I've attached a small sample of the data

See the attached updated spreadsheet.


Regards

You're welcome.

If this answers your question, please mark the thread as Solved.

http://www.excelforum.com/faq.php

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save