Recap: Imported Labels
Part of the Formulas and Data Analysis section of Coddy's Excel journey. Lesson 25 of 28.
Challenge
MediumRaw records in B2:B4 contain a name and numeric quantity separated by exactly one hyphen, for example East Team -12. Return the trimmed name in C2:C4 and numeric quantity in D2:D4. Names contain no hyphens; quantities are nonnegative plain integers.
Enter formulas in the highlighted output cells: C2, C3, C4, D2, D3, D4. Keep the supplied data and headings. Tests change input values, so use cell references instead of typing the sample answers. Use English function names and commas between arguments.
Try it yourself
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Row | Raw record | Name | Quantity | |||
| 2 | 1 | East Team -12 | |||||
| 3 | 2 | West-3 | |||||
| 4 | 3 | North Team -0 | |||||
| 5 | |||||||
| 6 | |||||||
| 7 | |||||||
| 8 | |||||||
| 9 | |||||||
| 10 | |||||||
| 11 | |||||||
| 12 | |||||||
| 13 | |||||||
| 14 |
All lessons in Formulas and Data Analysis
5Cleaning Imported Data
TRIM SpacesSUBSTITUTE TextFinding a DelimiterConverting Numeric TextRecap: Imported LabelsPractice on your own: Excel playground