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.
Excel Tips, Tricks, Cheats & Hacks – Notable Excel Websites (Non-MVP) Edition
Learn some Excel Tips, Tricks, Cheats & Hacks from some Notable [Non-MVP] Excel Websites.