Hello, I have a list of dimensions in an excel column and I need to extract the first 3 numbers in each of the rows.
For example, I have this in one of the cells
*** 21"W x 24"D x 31.5"H or 26.5" W x 22" D x 29" H, Seat Height: 19"
I want 21 in a new column, 24 in another new column, and 26.5 in a third new column. There is no standard to the way the dimensions are listed as you see with the other examples below.
Other examples of listed dimensions.
H30 x W79 x D39.5
48"l x 17.5"w x 38"h
H:24" W:54" D:28"
12x12x24
Is there a way to do this without manually going to 5000+ lines? Thank you ahead of time.
Bookmarks