bell23 Wrote:
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


--
zero635
------------------------------------------------------------------------
zero635's Profile: http://www.excelforum.com/member.php...o&userid=24802
View this thread: http://www.excelforum.com/showthread...hreadid=480187