Extract the 10 digit number [formula homework]
Okay, time for another challenge.
Imagine you have some data like this. Each cell contains 3 numbers separated by line break – CHAR(10) and you need to extract the number that is 10 digits long.
Go ahead and solve this riddle.
Post your answers in comments. Although the title says formula homework you are welcome to post VBA, Power Query and RegEx (thru VBA) solutions too.
Want to extract more?
If you derive pleasure extracting good data from junk, you are going to love below challenges.
- Extract numbers from text
- Extract first & last names from email addresses
- Extract file name from full path
- Extract dates from text
- Extract hourly rate by looking up a pattern
A note: These challenges are very interesting and can take up a lot of your time (thus make you a whole lot smarter).
Leave a Reply
|Excel Tips, Tricks, Cheats & Hacks – Notable Excel Websites (Non-MVP) Edition||Apply Conditional Formatting using Slicers|