Strip text before character

[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.

 

[Bob Phillips]

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]

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" <[email protected]> wrot
in
message news:[email protected]...

Bob, This selects out the dimensions in mm (results looks like 73 x 20
x 173). I am attempting to seperate out the inches dimensions. Th
digits in each dimension we are trying to remove can vary between
digits and 5 digits.
Thanks, Gar

 

[Bob Phillips]

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)