I need to convert text describing the dimensions, in feet and inches, of a three dimensional object into numbers in separate columns. Here's an example:
Convert 1'2" x 30'40" x 50'6" (all in one cell) into six separate columns containing 1 2 30 40 50 6
Convert 1'2" x 30'40" x 50'6" (all in one cell) into six separate columns containing 1 2 30 40 50 6