how to remove double quotes in excel
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
how to remove double quotes in excel
0
Answers
0
The formula below will remove both apostrophes.
=MID(Sheet2!$E2,2,16)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
Regards,
Akash Sharma
Akash Sharma (rep: 40) 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.
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: 4889) Oct 19, '18 at 3:01 pm
wow I like it
But what about if the number of letters are not the same? I am looking such solution but for me it doesnot work. I have like this"KazybekNogerbek_2020" and this"Mohammed2"datas in one column.
Do you have a solution to remove the quotes please?
But what about if the number of letters are not the same? I am looking such solution but for me it doesnot work. I have like this"KazybekNogerbek_2020" and this"Mohammed2"datas in one column.
Do you have a solution to remove the quotes please?
Lawdej (rep: 2) Sep 21, '20 at 9:53 am
You might use the SUBSTITUTE() function as demonstrated here.
@Lawdej, please take 5 minutes to edit your original question and make it more precise. Your comment yesterday is already completely different from the original question but the information isn't enough because you don't say where you want the formula to be. Morever, neither your comment nor your original question is linked to the workbook you uploaded in any way. Just ask a careful and exact question to get a careful and exact answer that you can work with.
@Lawdej, please take 5 minutes to edit your original question and make it more precise. Your comment yesterday is already completely different from the original question but the information isn't enough because you don't say where you want the formula to be. Morever, neither your comment nor your original question is linked to the workbook you uploaded in any way. Just ask a careful and exact question to get a careful and exact answer that you can work with.
Variatus (rep: 4889) Sep 21, '20 at 9:30 pm