Removing a quotation mark from a cell through a function.
 

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.

Removing a quotation mark from a cell through a function.
 

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.

Removing a quotation mark from a cell through a function.
 

Another way using substitute

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

If this post helps click Yes
---------------
Jacob Skaria


"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.

Removing a quotation mark from a cell through a function.
 

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.

Removing a quotation mark from a cell through a function.
 

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.