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

bell23 Wrote:
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


--
zero635
------------------------------------------------------------------------
zero635's Profile: http://www.excelforum.com/member.php...o&userid=24802
View this thread: http://www.excelforum.com/showthread...hreadid=480187

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

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