frankee_gee
Board Regular
- Joined
- Mar 3, 2008
- Messages
- 144
- Office Version
- 365
- 2016
- Platform
- Windows
Need some help with the following:
I trying to only extract the Height from the Size column "L X W X H" Need only the height
<colgroup><col width="72"></colgroup><tbody>
</tbody> =RIGHT(O64,FIND("x",O64))
returns:
<colgroup><col width="71"></colgroup><tbody>
</tbody>
if size is this:
<colgroup><col width="72"></colgroup><tbody>
</tbody> the formula returns :
<colgroup><col width="71"></colgroup><tbody>
</tbody>
I only want the characters to the right of the right most "X" ...in this case I want the "30" w/o the "x"
Appetite the help in advance.
Frankee.
I trying to only extract the Height from the Size column "L X W X H" Need only the height
60x53x30 |
<colgroup><col width="72"></colgroup><tbody>
</tbody>
returns:
x30 |
<colgroup><col width="71"></colgroup><tbody>
</tbody>
if size is this:
6x32x30 |
<colgroup><col width="72"></colgroup><tbody>
</tbody>
30 |
<colgroup><col width="71"></colgroup><tbody>
</tbody>
I only want the characters to the right of the right most "X" ...in this case I want the "30" w/o the "x"
Appetite the help in advance.
Frankee.