Feb 27 2022 05:53 AM
How do I extract ISBN's (Book identification numbers) from Text/Character strings within a cell?
ISBN's are 10 or 13 (13 in my specific case) number characters that identify a book. I will give some examples of how they are represented.
" xxxxxxxxxxxxx by xxxxxxx ISBN- 978xxxxxxxxxx"
"xxxxx by xxxxxx isbn: 978-xxxxxxxxxx"
"xxxxxxxxxxxxxx - xxxxxx isbn978xxxxxxxxx"
"978xxxxxxxxxx - by: xxxx - xxxxxxxxxxxxxxxxxxx"
So because there is no consistent cell contents the VBA I tried couldn't pick up what I was trying to accomplish.
I was thinking or trying to Google more or less how to extract text characters to leave numbers only, but I figured I would just reach out to a community for help regarding this specific issue.
Thanks for any help/advice!
Feb 27 2022 06:11 AM
@RKD2313 Relatively easy done with Power Query (PC only, though).
See attached.
Are you familiar with Power Query?
Feb 27 2022 08:52 AM
Feb 27 2022 12:26 PM
@RKD2313 The PQ example I gave keep any number in the text. I just used your example with the 978's and added some other numbers. bit that doesn't matter for. Only numbers will be kept. Having said that, if a book title contains a number, that number will also be kept. Best to give a complete picture of your problem.