I need a little help with a formula.
In column "A" I have dimensions like this in several rows.
I need to put each dimension in column "B", column "C" and for the "Third" dimension column "D".
I have a formula in column "B" for the first dimension, column C for the second dimension. and column "D" for the third dimension. But, the formula in column "D" will not give me the correct data. It give me the second dimension.
Here's the formula I used for the third dimension.(columnD). I used column A thu D for this post.
=RIGHT($L2,LEN($L2)-FIND("*",SUBSTITUTE($L2," ","*",LEN($L2)-LEN(SUBSTITUTE($L2," ","")))))
Row 1 Column A: 12 x 12 x12
Row 2 Column A: 234 x 34 x 96
Here's where I'm having a problem
Row 3 Column A: 356 x 22
'''' note this row only has 2 dimensions and the formula show will show the second dimension in column D
The formulas I have for column B and C works just fine.
Thanks