Menu
Coddy logo textTech

Recap: Imported Labels

Part of the Formulas and Data Analysis section of Coddy's Excel journey. Lesson 25 of 28.

challenge icon

Challenge

Medium

Raw 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

Sheet1
ABCDEFG
1RowRaw recordNameQuantity
21 East Team -12
32West-3
43 North Team -0
5
6
7
8
9
10
11
12
13
14

All lessons in Formulas and Data Analysis

Practice on your own: Excel playground