Explanation
Sometimes you encounter data that mixes units directly with numbers (i.e.
8km, 12v, 7.5hrs).
To split a number from a unit value, you oughta determine the position of thelast number.
If you add 1 to that position, you have the start of the unit text.
This formula uses this concept to figure out where the unit of measure begins.
MAX ignores empty cells, the logical values TRUE and FALSE, and text values.
For example, =LEFT(“apple”,3) returns “app”.
For example, =RIGHT(“apple”,3) returns “ple”.
VALUE Function
The Excel VALUE function converts text that appears in a recognized format (i.e.
a number, date, or time format) into a numeric value.
Normally, the VALUE function is not needed in Excel, because Excel automatically converts text to numeric values.
For example, =MID(“apple”,2,3) returns “ppl”.
