One way:

A1 = 11"

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

--
Biff
Microsoft Excel MVP


"Ryan" wrote in message
...
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.