Pulling Specific Text from a String of Text

[srsev]

I have enjoyed many of the posts and responses about pulling text from a string of text and learned some new formulas. Thank you all.

Unfortunately I did not find what I needed for my spreadsheet. It seems all the formulas I am seeing are pulling text from a string of text that start at a certain character location. My data is not all the same as far as location of the "PO#####" characers. The only commonality in each cell is the "PO". Is there a way for excel to search for "PO" and then pull up to 8 characters beginning with P?

For the examples below, I want to pull the PO numbers.
Row 1 = PO-14885
Row 2 = PO16326
Row 3 = PO16326

<TABLE style="WIDTH: 827pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1103 border=0><COLGROUP><COL style="WIDTH: 827pt; mso-width-source: userset; mso-width-alt: 40338" width=1103><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 827pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=1103 height=20>Task 001/Task/TU ABC 2/TU 794 F1 (Task:Equipment) PO-14885 TU2 794 F1 5 - COTUINATE Phone CHANGE FOR Removed WITH ABC in queue .MW.TU is ready.</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Task BUNDLE 2 /AGG/SEV ABC 1/SEV 003 (ABCDEFGI:Equipment) PO16326 SEV 003 CSR 5 - ASSIGN Your tasks NUMBER/ 7750 Tool PORTS in queue .West.SEV is ready.</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Task SEV 003 (Your SITE) PO16326 SEV 003 CSR 3B - ADD 7705 Tool TO T1 PATH in queue AB.West.SEV is ready.</TD></TR></TBODY></TABLE>

I get hundreds of these notifications a day and need to only pull the PO number. My spreadsheet begins on cell A2 and remains in column A but extends to row 100 +.

You can also see that the commonality is the PO. This remains constant.

Any help would be greatly appreciated. Thanks.

 

[Haseeb Avarakkan]

Hello,

Try this B2 & copy down...

=TRIM(MID(A2,SEARCH("PO",A2),8))

 

[hiker95]

srsev,

Excel Workbook
	A	B
1	Task 001/Task/TU ABC 2/TU 794 F1 (Task:Equipment) PO-14885 TU2 794 F1 5 - COTUINATE Phone CHANGE FOR Removed WITH ABC in queue .MW.TU is ready.	PO-14885
2	Task BUNDLE 2 /AGG/SEV ABC 1/SEV 003 (ABCDEFGI:Equipment) PO16326 SEV 003 CSR 5 - ASSIGN Your tasks NUMBER/ 7750 Tool PORTS in queue .West.SEV is ready.	PO16326
3	Task SEV 003 (Your SITE) PO16326 SEV 003 CSR 3B - ADD 7705 Tool TO T1 PATH in queue AB.West.SEV is ready.	PO16326
4
Sheet1

The formula in cell B1, copied down:

=MID(A1,FIND("PO",A1,1),FIND(" ",A1,FIND("PO",A1,1))-FIND("PO",A1,1))

 

[srsev]

Both of these formulas worked perfectly. Thank you so much. You all are absolutely fantastic!