Removing " " from a cell

G

GTT

I downloaded a file which has the extension .csv. It has a column of
numbers but they are preceded and followed by " like this "4293226"
and I am trying to create a formula that subtracts the second row,
third row.... to the end number from the first row number. I get a
#VALUE!. Is there a simple way to remove the "" from each number?
 
D

Dave Peterson

Select the range to fix
Edit replace
what: "
with: (leave blank)
replace all

Maybe the quickest way.
 
Top