shahid5788
Board Regular
- Joined
- May 24, 2016
- Messages
- 91
Hi,
I have alot of random data. I am trying to find a formula that will extract the "PO" from my memo cells. A formula that will look into the cell and find that specific PO and extract to my other column? Can anyone please assist?
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I have alot of random data. I am trying to find a formula that will extract the "PO" from my memo cells. A formula that will look into the cell and find that specific PO and extract to my other column? Can anyone please assist?
MEMO | What I want | |
Invoice - California - California University of: PF 547548 Sales Orders Billing - PO573 | PO573 | |
Invoice - AFLAAC (U.S. Air Force Academy): 200hdi, dariW2 PO201 | PO201 | |
Invoice - Oklahoma State University: 300drt, htfJW2, vertical orientation (w/tircero kemur top plate) PO630 | PO630 | |
Invoice - New York State University: PL 874541 Sales Orders Billing - PO847 | PO847 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>