Quote Originally Posted by bell23
Hello,
I need to strip text in a cell and have attempted a number of solutions without total sucess. The cell data consists of dimensional information:
73 mm (2.9 in)H x 208 mm (8.2 in)W x 173 mm (6.9 in)D
I need to craft a formula that would return the following result:
2.9 x 8.2 x 6.9

Any help is greatly appreciated.

Bell,

Not sure if this will help you but it works, try the following formula in a empty sell next to the cell you are trying to convert.

=MID(A1,8,3) &" x "& MID( A1,27,3) & " x " & MID(A1, 46,3)

This will trim it down to exactly what you want. I assumed your data is in cell A1, if not change the A1's to what ever cell you are working with. If you need to do more then one cell, copy the cell you have this in and copy down or up which ever then you can paste special values to concrete it into the spreadsheet. Let me know if this helps.

Good Luck,
Zero