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

Variable

Results

Formula

<tbody>
</tbody>

15" $ 30.00 "=SUM(((LEFT($E15,2)*2)))" <tbody> </tbody> 15.5" $ 30.00 "=SUM(((LEFT($J8,2)*2)))" <tbody> </tbody> 15.5" $ 31.00 "=SUM(((LEFT($J9,4)*2)))" <tbody> </tbody>

<tbody>
</tbody>

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.