I'm trying to extract a alphanumeric string from a mixed string.
Per the example below the text I need to extract is a "Pxxxxx", where the xxxxx could be any length but is always numbers.
The Source cell could be any length and contain other mixed text.
<tbody>
</tbody><colgroup><col><col></colgroup>
Any help would be greatly appreciated.
Jim
Per the example below the text I need to extract is a "Pxxxxx", where the xxxxx could be any length but is always numbers.
The Source cell could be any length and contain other mixed text.
Source Cell | Required Results |
Project P1234567 for Org 2005-2017 | P1234567 |
P012345 | P012345 |
<tbody>
</tbody><colgroup><col><col></colgroup>
Any help would be greatly appreciated.
Jim