Has to be done in Excel using these formulas: LEFT, RIGHT, MID, CONCATENATE, VAL

Question

Has to be done in Excel using these formulas: LEFT, RIGHT, MID, CONCATENATE, VALUE, LEN

Q5: Write one formula in column B to extract the number of copies. Make sure that you make the output a numeral value.

Q5 01 02 03 Q4 Movies (no space) BetweentheWorldand Me128 AnEmberintheAshes50 TheNightingale25 TheWrightBrothers34 HlsforHawk9 TheGirlontheTrain86 MemoryMan250 Roguelawyer74 TheGirlintheSpider'sWeb2480 GoSetaWatchman70 Seveneves480 Mark the last space 5 Between the World and Me 128 Position of last space 2 Books 3 Between the World and Me 128 4 An Ember in the Ashes 50 5 The Nightingale 25 6 The Wright Brothers 34 7 H Isfor Hawk 9 8 The Girl on the Train 86 9Memory Man 250 10 Rogue Lawyer 74 11 The Girl in the Spider's Web 2480 12 Go Set a Watchman 70 13 Seveneves 480 14 15 #Copies #space An Ember in the Ashes 50 2 The Nightingale 25 3 The Wright Brothers 34 4 HIsfor Hawk9 5 The Girl on the Train 86 2 Memory Man 250 2 Rogue Lawyer 74 6 The Girl in the Spider's Web 2480 4 Go Set a Watchman 70 1 Seveneves 480 16 20 14 13 29 18 10

Explanation / Answer

Here' the answer:

You may use either of these formulae to solve the problem:

=VALUE(RIGHT(A3, FIND(" ",A3)-2))

=VALUE(TRIM(RIGHT(SUBSTITUTE(A3," ",REPT(" ",255)),255)))

There is no way you can find the no. of copies without using only the formula given in the question

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.