how to remove double quotes in excel

0

how to remove double quotes in excel

Answer
Discuss

Answers

0

The formula below will remove both apostrophes.

=MID(Sheet2!$E2,2,16)
Discuss

Discussion

Wow very well answered. May you please guide why sheet2 was selected whilst using mid formula and why dollar sign was inserted before E2?
Regards,
Akash Sharma
Akash Sharma (rep: 24) Oct 19, '18 at 2:14 pm
No particular reason for selecting Sheet2. I might have selected Sheet1. The important thing was to select one of the values with the embracing apostrophes, and I did want to show how to address a cell from another sheet because I felt that is what you would probably have to do.
The $ sign before the column spec is significant if you wish to copy the formula to a column other than the one where it was first pasted. $ signs, as you know, specify absolute addressing, and absolute addressing is different from relative addressing only when formulas are copied. Since it is relatively rare that formulas are not copied I advise to make writing $ signs the default for both columns and rows. Therefore you might ask why there is no $ sign for the row. I omitted that $ sign because I wanted to enable copying down of the formula when  the row number should change, and I didn't omit it for the column to facilitate copying horizontally when the referenced column should always remain column E.
Variatus (rep: 2523) Oct 19, '18 at 3:01 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login