Strip text before character

B

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

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)
 
B

bell23

Bob said:
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]...
Click to expand...

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
 
B

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)
 
Top