Return Everything before a string plus additional two " "s

[Veleric]

I am trying to return everything before a specific string as well was the next two spaces or more specifically the next text string following.

Example: JASON THOMPSON 123 MAIN ST PO BOX 184 NOWHEREVILLE ID 46582
Parameters: Searching for string "PO BOX" (with or without spaces depending on formula)
Desired Output: JASON THOMPSON 123 MAIN ST PO BOX 184

The location of the searched string (in this case PO BOX) is not predictable, so it can't be set at a specific location or number of spaces or anything, it needs to be able to change according to the record/cell data.

The above request is the most important part, but I would also really appreciate the ability to pull this from the right side as well, so "PO BOX 184 NOWHEREVILLE ID 46582"

Please let me know if further information is required.

Thanks!

 

[Z51]

First request:

=MID(A1,FIND("PO BOX",A1),FIND(" ",A1,FIND("PO BOX",A1)+7)-FIND("PO BOX",A1))

Second request:

=MID(A1,FIND("PO BOX",A1),LEN(A1))

Edit: I misread the first request, thought you just wanted the PO BOX info. To get the text from the left through the PO BOX info, try:

=LEFT(A1,FIND(" ",A1,FIND("PO BOX",A1)+7)-1)

 

[Veleric]

Exactly what I needed. Thank you!!