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!
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!