How can I have Google Sheets automatically parse and calculate text that follows a certain pattern?

by user666   Last Updated May 16, 2019 00:03 AM

I have the following sheet:

https://docs.google.com/spreadsheets/d/1iEMjWVEwyuqbn_imW1UZ-AF2NlE__IbRZdHQifKJjko/edit?usp=sharing

I would like to calculate "Total Work" by deriving it from my own notation. When I do 6 sets of 10 reps of benchpress at 200lbs, I want to write and see 6x10x200, but then in addition, see a "total work" computation that recognizes the pattern NUMxNUMxNUM, or NUMxNUMxNUM, NUMxNUMxNUM

If this problem would become much easier to solve with some adjustments to my notation, for example, NUM*NUM*NUM, this would work perfectly fine.

Tags : google-sheets


Related Questions


Updated March 03, 2018 02:03 AM

Updated September 19, 2018 13:03 PM

Updated July 26, 2018 21:03 PM

Updated November 29, 2018 16:03 PM

Updated January 18, 2019 09:03 AM