If cell contains

[billandrew]

Good morning

Wondering if it is conceivable to search if a cell contains "PO" "PO1", "PO3" up to possibly "PO8" in a string and return the data on the left which will be separated by a space.

Ex.


Northwest 654 PO1 ID236

The "PO" is not in the same position in all cells.

Thank you

 

[Peter_SSs]

You didn't say what should be returned if "PO" is not found in the cell. This suggestion returns nothing in that case.
If this is not what you need please give 5-10 samples of data and the expected results. You make it hard if we have to guess from one example only.

=IFERROR(LEFT(A1,FIND(" PO",A1)-1),"")

 

[billandrew]

Once again, I believe you are reading my mind. Works perfect.

Thank You.

 

[billandrew]

Question if I may, Is the space preceding the PO intentional.

 

[Peter_SSs]

Question if I may, Is the space preceding the PO intentional.

Yes. You only gave one example of data and it had a space before the PO.

 

[billandrew]

Yes it does.

Thank You again sir.