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" <bell23.1xmrmk_1130533521.2857@excelforum-nospam.com> wrote in
message news:bell23.1xmrmk_1130533521.2857@excelforum-nospam.com...
>
> 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" <bell23.1xmjai_1130522724.4244@excelforum-nospam.com> wrote
> > in
> > message news:bell23.1xmjai_1130522724.4244@excelforum-nospam.com...
> > >
> > > 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
>