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).
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Excel Tips, Tricks, Cheats & Hacks – Notable Excel Websites (Non-MVP) Edition||Apply Conditional Formatting using Slicers »|