Gary,
Try this then
B1: =LEFT(A1,FIND("mm",A1)-1)
C1: =MID(A1,FIND(" x ",A1)+3,FIND("mm",A1,FIND("mm",A1)+1)-1-(FIND(" x
",A1)+3))
D1: =MID(A1,FIND(" x ",A1,FIND(" x
",A1)+3)+3,FIND("mm",A1,FIND("mm",A1)+1)-1-(FIND(" x ",A1)+3))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"bell23" wrote in
message ...
Bob Phillips Wrote:
Do it in 3 stages
=LEFT(A1,FIND("mm",A1)-1)&MID(A1,FIND(")",A30)+2,99)
and then copy across to B1 and C1 and then down
--
HTH
RP
(remove nothere from the email address if mailing direct)
"bell23" wrote
in
message ...
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.
--
bell23
------------------------------------------------------------------------
bell23's Profile:
http://www.excelforum.com/member.php...o&userid=28425
View this thread:
http://www.excelforum.com/showthread...hreadid=480187
Bob, This selects out the dimensions in mm (results looks like 73 x 208
x 173). I am attempting to seperate out the inches dimensions. The
digits in each dimension we are trying to remove can vary between 2
digits and 5 digits.
Thanks, Gary
--
bell23
------------------------------------------------------------------------
bell23's Profile:
http://www.excelforum.com/member.php...o&userid=28425
View this thread: http://www.excelforum.com/showthread...hreadid=480187