Why -- in that formula ?
What's wrong with + ?
--
David Biddulph

"Gary''s Student" wrote in message
...
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.
--
Gary''s Student - gsnu200907


"Ryan" wrote:

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.