L33
Board Regular
- Joined
- Jul 2, 2008
- Messages
- 108
Hi,
I need to use Power Query (in Excel) to extract from a long list of free text strings any instances of a 8-digit number that begins with a 4. This could be anywhere within the free text or no where. I need a new column that extracts that number, or returns null (and, in what would hopefully be incredibly rare event, just one instance when multiple matches are found).
Is there a simple way that I've missed? I have a nagging feeling that there is.
Any assistance gratefully received...
I need to use Power Query (in Excel) to extract from a long list of free text strings any instances of a 8-digit number that begins with a 4. This could be anywhere within the free text or no where. I need a new column that extracts that number, or returns null (and, in what would hopefully be incredibly rare event, just one instance when multiple matches are found).
Is there a simple way that I've missed? I have a nagging feeling that there is.
Any assistance gratefully received...