Text
Split L x W x H dimensions ("24 x 18 x 12") into numbers and volume
Parse 2D or 3D carton dimension text into numeric Length, Width, Height, and cubic volume using TEXTBEFORE, TEXTAFTER, and VALUE.
Normalize spaces and "X"/"x" delimiters first
Supplier catalogs mix "24 x 18 x 12" and "10X10X5". Normalizing with s = SUBSTITUTE(LOWER(A2), " ", "") produces a uniform "24x18x12" token string.
TEXTBEFORE(s, "x") extracts Length, TEXTBEFORE(TEXTAFTER(s, "x"), "x") extracts Width, and TEXTAFTER(s, "x", 2) extracts Height; wrapping each in VALUE turns text into numbers ready for cubic volume and carrier dim-weight math.
| BoxSpec (A) | Length | Width | Height | Cubic Volume |
|---|---|---|---|---|
| 24 x 18 x 12 | 24 | 18 | 12 | 5184 |
| 10X10X5 | 10 | 10 | 5 | 500 |
Length, Width, Height, and Cubic Volume formulas
As a hypothetical shipping rule, dividing 5,184 cubic inches by 139 and rounding up yields 38 lb of dimensional weight. The divisor, dimensional rounding, and comparison with actual weight depend on the carrier/service policy.
=LET(s, SUBSTITUTE(LOWER(A2), " ", ""), VALUE(TEXTBEFORE(s, "x")) * VALUE(TEXTBEFORE(TEXTAFTER(s, "x"), "x")) * VALUE(TEXTAFTER(s, "x", 2)))Extract middle Width dimension
TEXTBEFORE(TEXTAFTER(s, "x"), "x") isolates the middle 18 cleanly.
=LET(s, SUBSTITUTE(LOWER(A2), " ", ""), VALUE(TEXTBEFORE(TEXTAFTER(s, "x"), "x")))Inputs and interpretation
Require exactly three positive numeric dimensions in the same unit, separated by x or X. The multiplication sign ×, unit suffixes, missing fields, and extra fields need normalization/validation first. Cubic volume uses the cube of the input unit.
Try the example
Use the original values or change them to test your understanding.