Dear Demigods,
In cell A1 I have "120x50x120"
In B1 I have the formula =LEFT(A1,FIND("X",A1)-1)
This extracts the first numeric value before the first "X".
The numerical values can be two to three numbers big.
How can I extend the formula so that it extracts the first number into B1, second number into C2 and third number into D2?
The end user may also enter A1 as "120 x 50 x 120", so I have to take the spaces into consideration also.
Your help, as always, is greatly appreciated.
Best Regards
manc
In cell A1 I have "120x50x120"
In B1 I have the formula =LEFT(A1,FIND("X",A1)-1)
This extracts the first numeric value before the first "X".
The numerical values can be two to three numbers big.
How can I extend the formula so that it extracts the first number into B1, second number into C2 and third number into D2?
The end user may also enter A1 as "120 x 50 x 120", so I have to take the spaces into consideration also.
Your help, as always, is greatly appreciated.
Best Regards
manc