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