SUM ? ? =TRIM(MID(SUBSTITUTE($All, delim,REPT(\"\",LEN(SA11))),(E$10-1)\"LEN($A1

Question

SUM ? ? =TRIM(MID(SUBSTITUTE($All, delim,REPT("",LEN(SA11))),(E$10-1)"LEN($A11)+1,LEN($All)) 5 06/26/2018 07:54:14, 1.7500,HI 6 06/26/2018 07:58:09, 1.7494,GO 7 06/26/2018 08:02:05, 1.7493,LO 8 06/26/2018 08:06:00, 1.7492,LO 9 06/26/2018 08:09:55, 1.7493,LO 10 06/26/2018 08:13:51, 1.7494,GC 11 (06/26/2038 08:1746, 1.7494,60 TRIM(MID(SUBSTITUTE(SA11, delim,REPTLENS11 ES10-1 LENISA11+LEN(SA11) 12 06/26/2018 08:21:41, 1.7493,L0 13 06/26/2018 08:25:37, 1.7491,LO 14 06/26/2018 08:29:32, 1.7494,GO 15 06/26/2018 08:33:28, 1.7494,GO 16 06/26/2018 08:37:23, 1.7492,LO 17 06/26/2018 08:41:18, 1.7494,GO 6/26/2018 7:58:09 1.7494 GO 6/26/2018 8:02:05 1.7493 LO 6/26/2018 8:06:00 1.7492 LO

Explanation / Answer

The function given above will work, but you'll have to copy the formula across using the autofill drag thingy.
Also I'm not sure what is delim here.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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