Take three characters starting at the second character. Follow a five-row grocery spending example with the exact formula and an expected result. This worked guide uses a small reproducible example so you can check the result before adapting it to your own task.
Voordat je begint
- A spreadsheet application supporting the listed functions, such as current Excel or Google Sheets
- A blank worksheet
- Five sample rows; no private information is needed
Stapsgewijze handleiding
Create a small sample table
Open a blank worksheet. Enter these labels in column A and numbers in column B. Keep the header in row 1 and the five observations in rows 2–6.
A1: Item | B1: Amount
A2: Rice | B2: 18
A3: Beans | B3: 12
A4: Apples | B4: 9
A5: Bread | B5: 6
A6: Oats | B6: 15
Keep the inputs numeric
Select B2:B6 and use a plain Number format. Enter only the number in each cell; put the unit, amount, in the header. A value such as "18 amount" is text and can change what numeric formulas include.
Enter the formula in a separate cell
Click D2 and type this formula, including the initial equals sign. Press Enter. Take three characters starting at the second character. Use ordinary straight quotation marks in formulas; typographic quotation marks are not valid formula delimiters.
=MID(A2,2,3)Check the worked result
With the sample data exactly as shown, D2 should return ice. If the result differs, compare the cell references and make sure the formula covers rows 2–6. Decimal results may be displayed with fewer decimal places depending on the cell format.
Adapt the range and verify a real row
Replace the sample with your own grocery spending only after the worked result matches. Expand B2:B6 and A2:A6 together when adding rows. Check one observation and one final result manually before using the worksheet.
Tips en probleemoplossing
- These examples use comma argument separators. Some regional settings require semicolons instead.
- Use straight quotes, and preserve absolute references marked with $.
- Percentage formulas return fractions; apply a Percentage format when that display is appropriate.
Veelgestelde vragen
Why does the spreadsheet show the formula instead of a result?
Change the cell format from Text to General, edit the formula, and press Enter again. Make sure the first character is =.
Can I use more than five rows?
Yes. Extend every related range to the same final row and test the result against a small subset first.
