strangebiscuit
New Member
- Joined
- Nov 25, 2013
- Messages
- 35
Hi, I've got what seems like a simple conversion task that I'm having trouble puzzling out.
I have a column of product descriptions (text/html) that contain measurements (i.e. "Medium - 6.3cm x 7cm") and I need to find and convert them from cm to inches. I'm having trouble figuring out how to grab the numbers before the "cm" so I can convert them.
I'm fine to do a search/replace for the actual unit of measurement (i.e. changes "cm" to "inches"), but how do I isolate and convert just the numbers that come before the unit?
Would be happy to just do this as a formula in an adjacent column if possible and copy/paste the whole thing, but also fine to use a macro if it makes it easier to figure out.
There are no spaces between the numbers and the unit of measurement.
Need to end up with something like this:
<tbody>
</tbody>
Thanks in advance for any tips you can provide, greatly appreciated!
I have a column of product descriptions (text/html) that contain measurements (i.e. "Medium - 6.3cm x 7cm") and I need to find and convert them from cm to inches. I'm having trouble figuring out how to grab the numbers before the "cm" so I can convert them.
I'm fine to do a search/replace for the actual unit of measurement (i.e. changes "cm" to "inches"), but how do I isolate and convert just the numbers that come before the unit?
Would be happy to just do this as a formula in an adjacent column if possible and copy/paste the whole thing, but also fine to use a macro if it makes it easier to figure out.
There are no spaces between the numbers and the unit of measurement.
Need to end up with something like this:
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col></colgroup><tbody> </tbody> | ||
<colgroup><col></colgroup><tbody> </tbody> | Medium 4.5cin x 2.6in - blah blah blah <tbody></tbody> | ||
<colgroup><col></colgroup><tbody> </tbody> | Range: from 2in x 2in to 5.9in x 2in. Blah blah blah |
<tbody>
</tbody>
Thanks in advance for any tips you can provide, greatly appreciated!