Further to my question of yesterday.
I have a similar problems extracting a P ####### ID from a string, as shown in the attached sample. Adapting the formula from yesterday to find PCD numbers does not seem to work.
The required answer is shown in the adjacent column to the Source Cell data
GeorgiaBrown
Bookmarks