Strip text before character

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.

Originally Posted by 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.

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

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
>

Originally Posted by 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" <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

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
>