Twist: numbers stuck in words
Your task First type B7: =SUM(A2:A5) and see 0. Then put =VALUE(TEXTBEFORE(A2," ")) in B2, fill it down to B5, and make B7 the SUM of B2:B5.
Getting the editor ready
Twist: numbers stuck in words
Your task First type B7: =SUM(A2:A5) and see 0. Then put =VALUE(TEXTBEFORE(A2," ")) in B2, fill it down to B5, and make B7 the SUM of B2:B5.
Getting the editor ready