![]() Once you have found your first Stem value, drag the fill handle to the bottom of the column to execute the formula for the remaining cells ( C3:C25). The LEFT function-which returns the specified number of characters from the start of a cell-will help us extract the first digit from each value while the VALUE function formats the formula output as a number (that’s crucial).Įnter this formula into cell C2: =VALUE(LEFT(A2,1))
0 Comments
Leave a Reply. |