VALUE of the number at the start of a cell
"12 boxes" is text; the 12 inside it can be a number.
Task:
Goods-in notes record quantities like 12 boxes or 140 units. In C2:C6 extract the quantity as a real number — the digits before the first space.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of VALUE
0/3The same formula in the other shapes it takes at work.
- VALUE Function
Numbers that arrived as text, and will not behave until you convert them.
CoreIntermediate - Strip symbols, then VALUE
Text with a currency sign and thousands separators has to be cleaned before it converts.
Advanced - VALUE of the number at the start of a cell
"12 boxes" is text; the 12 inside it can be a number.
Intermediate
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Delivery | Note | Qty |
| 2 | D-1 | 12 boxes | |
| 3 | D-2 | 140 units | |
| 4 | D-3 | 6 pallets | |
| 5 | D-4 | 1000 sheets | |
| 6 | D-5 | 48 rolls |
What this exercise teachesMay contain the answer
Text functions always return text, so the 12 that LEFT hands back will not add up with other numbers — SUM simply skips it. VALUE is the last step that makes an extracted figure usable.