Need a formula to extract length x width x height from a single column into three columns.
Sample data:
31/2" x 25/8" x 11/4 extract into separate columns as 3 1/2" 2 5/8" 1 1/4"
131/2" x 8" x 63/4" extract into separate columns as 13 1/2" 8" 6 3/4"
The max length of whole number is two (two digits/characters.
Dropping this in from another program but want to separate for netter filterability.
Sample data:
31/2" x 25/8" x 11/4 extract into separate columns as 3 1/2" 2 5/8" 1 1/4"
131/2" x 8" x 63/4" extract into separate columns as 13 1/2" 8" 6 3/4"
The max length of whole number is two (two digits/characters.
Dropping this in from another program but want to separate for netter filterability.