In this video, we look at how to concatenate strings that have double quotes in them. Its a simple concept that needs to be understood by every excel users.
We talk of 2 different methods to achieve this.
One is by escaping the double quote.
Second is by using the binary equivalent of " in our concat formula.
Link to the companion worksheet - https://drive.google.com/open?id=1xST...
#excelconcat #exceltricks #exceltips