Removing " " from a cell

  • Thread starter Thread starter GTT
  • Start date Start date
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?
 
Select the range to fix
Edit replace
what: "
with: (leave blank)
replace all

Maybe the quickest way.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top