Return text on right most of size

[frankee_gee]

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>
[TD="class: xl65, width: 72"]60x53x30
[/TD]

</tbody>

=RIGHT(O64,FIND("x",O64))

returns:

<colgroup><col width="71"></colgroup><tbody>
[TD="width: 71"]x30
[/TD]

</tbody>

if size is this:

<colgroup><col width="72"></colgroup><tbody>
[TD="class: xl65, width: 72"]6x32x30
[/TD]

</tbody>

the formula returns :

<colgroup><col width="71"></colgroup><tbody>
[TD="width: 71"]30[/TD]

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

 

[Jonmo1]

Try this, assuming it's always 2 x's in the string.

=REPLACE(O64,1,FIND("x",O64,FIND("x",O64)+1),"")

 

[frankee_gee]

Jonmo1 - perfect....exactly what we needed.

Appreciate the help Bud.

Frankee

 

[Jonmo1]

You're welcome.