Cell with an expression and using the Left formula

[Wkruger]

I'm trying to multiply a cell with a constant and that has a non-numeric value. Example 15" (" = inches). I used the "Left" formula and it works. However, the data changes in size and would have to change the value of the Left formula from 2 to 4. Is there a better way of doing this? Like an SumIf command or formula that ignores the non numeric expression

I tried using the right command, but not sure if it will allow me to look at value after the expression IE: -1

[TABLE="width: 384"]
<tbody>[TR]
[TD="class: xl66, width: 79"]Variable[/TD]
[TD="class: xl66, width: 87"]Results[/TD]
[TD="class: xl66, width: 9"][/TD]
[TD="class: xl66, width: 9"][/TD]
[TD="class: xl66, width: 103"]Formula[/TD]
[TD="class: xl66, width: 75"][/TD]
[TD="class: xl65, width: 11"][/TD]
[TD="class: xl65, width: 11"][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 453"]
<tbody>[TR]
[TD="colspan: 5"][TABLE="width: 453"]
<tbody>[TR]
[TD]15"[/TD]
[TD] $ 30.00[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 5"] "=SUM(((LEFT($E15,2)*2)))"[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 453"]
<tbody>[TR]
[TD]15.5"[/TD]
[TD] $ 30.00[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"] "=SUM(((LEFT($J8,2)*2)))"[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 453"]
<tbody>[TR]
[TD]15.5"[/TD]
[TD] $ 31.00[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"] "=SUM(((LEFT($J9,4)*2)))"[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Any insight would be appreciated

Thank you

 

[AlphaFrog]

Can the variables be just numeric values with custom number formatting to display the inches symbol?

Custom cell format: 0.0''
The '' is two single quotes and not one double quote

 

[Wkruger]

No, it is pre- populated and would have to change too many. Any suggested formula I can use? By the way ty for the reply

 

[AlphaFrog]

Try something like this...

=LEFT(A1,LEN(A1)-1)*2

 

[Wkruger]

Great solution, as it worked! Thank you for your help....

 

[Wkruger]

By the way, do I need to do anything to close this this post? I searched and did not see anything or missed it

 

[AlphaFrog]

By the way, do I need to do anything to close this this post? I searched and did not see anything or missed it

You're good and you're welcome.