Text › MID, VALUE54 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

MediumFreeMIDVALUE

MID & VALUE: pack weight from the product code

Rizky runs a Gayo coffee roastery in Takengon. His product codes follow a fixed format: 3 letters for the coffee type, a hyphen, 4 digits for the weight in grams, a hyphen, then the grind code. Example: ARB-0250-B means arabica, 250 grams, whole bean.

Task

Fill B2:B6 with the pack weight in grams as a number (not text), taken from the code in column A. Use MID to pull out the 4 weight digits and VALUE to turn them into a number.

Cells to fillB2:B6

Required functionsMIDVALUE

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
The weight always sits in characters 5 to 8. MID(text, start_position, number_of_characters) takes a slice from the middle of a text.
Hint 2
The result of MID is always text, such as "0250". VALUE turns numeric text like that into the number 250.
Hint 3
Pattern: =VALUE(MID(A2, …, …)). Count the start position: A, R, B, the hyphen, then the first weight digit.

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

B2:B6

=VALUE(MID(A2,5,4))

Write it in B2, then fill down to B6.

Explanation

MID(A2,5,4) takes 4 characters starting at character 5, which is "0250", and VALUE turns it into the number 250, so the leading zero disappears and the value can be summed. Without VALUE the result is text: SUM would ignore it and the total would be 0. A short form you will often see: =--MID(A2,5,4) (a double minus). This kind of formula is only safe when the format is truly fixed; when the parts vary in length, use TEXTBEFORE/TEXTAFTER.

Starting worksheet: Sheet1
Row	A	B
1	Product code	Weight (grams)
2	ARB-0250-B
3	ROB-1000-G
4	LIB-0500-B
5	ARB-0100-G
6	ROB-0200-B
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result