Removing a quotation mark from a cell through a function.

  • Thread starter Thread starter Ryan
  • Start date Start date
R

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.
 
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.
 
Another way using substitute

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

If this post helps click Yes
 
Back
Top