Extract the 10 digit number [formula homework] | Chandoo.org - Learn Microsoft Excel Online
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. Continue »...