After my post on Concatenation in Excel, there was a question on how to concatenate Double Quotes (") in the formula. You might think it's complicated, but its actually very simple.
Just insert two double quotes inside the parent double quote to display one double quote in the final result.
Confusing? Let me explain.
Assume, this is how your spreadsheet is:
Now carefully count the number of double quotes in the formula, and see how it reflects in the Result cell.
Hope this helps.
Just insert two double quotes inside the parent double quote to display one double quote in the final result.
Confusing? Let me explain.
Assume, this is how your spreadsheet is:
So to get our result as above, we need to use the formula as -
Now carefully count the number of double quotes in the formula, and see how it reflects in the Result cell.
Hope this helps.
