Removing a quotation mark from a cell through a function.

[Ryan]

I would like to use a function(s) to remove a quotation mark from a cell.
Currently I have a cell that users enter a length, such as 11" or 101" and I
would to use just the number portion in a subsequent function.

 

[Gary''s Student]

Say A1 has the value. rather than:
=30+A1
use:
=30--LEFT(A1,LEN(A1)-1)

this discards the double quote and makes it a number.

 

[Jacob Skaria]

Another way using substitute

=SUBSTITUTE(A1,CHAR(34),)+0
OR
=--SUBSTITUTE(A1,CHAR(34),)

If this post helps click Yes

 

[T. Valko]

One way:

A1 = 11"

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