Concatenating strings with quotes in excel

preview_player
Показать описание
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.

#excelconcat #exceltricks #exceltips
Рекомендации по теме
Комментарии
Автор

Thank you, but 34 is ASCII value of double quote not binary equivalent, binary equivalent of 34 is 00100010

BR-rxfp