Hello,
I have a column of cells that can be anywhere from 0 characters - 2,000 characters. I am trying to extract from this cell a code; if the code exists - extract it, if it doesn't, tell me it doesn't. The code always starts with "OL_" and is followed by numbers (i.e OL_123, OL_4562, OL_90). This code can be anywhere within the cell. Also, it is possible that there is a letter value which is after the last number (i.e. OL_56234a, OL_90H). I do not want those letter values.
I hope the below helps to see what I need. Column B are the results I need.
<tbody>
</tbody>
I have a column of cells that can be anywhere from 0 characters - 2,000 characters. I am trying to extract from this cell a code; if the code exists - extract it, if it doesn't, tell me it doesn't. The code always starts with "OL_" and is followed by numbers (i.e OL_123, OL_4562, OL_90). This code can be anywhere within the cell. Also, it is possible that there is a letter value which is after the last number (i.e. OL_56234a, OL_90H). I do not want those letter values.
I hope the below helps to see what I need. Column B are the results I need.
A | B | |
1 | OL_123 - Please Keep | OL_123 |
2 | OTHER: OL_4362465 - Discard | OL_4362465 |
3 | Other: OL_010a | OL_010 |
4 | OL_555a - Trust | OL_555 |
<tbody>
</tbody>