Why are the Quotation marks in Microsoft Word different from the one in .csv?
Hi Brightspace,
Here's the context:
Our lecturers have a set of quiz questions that they had written out in a word document file before using the given BS Quiz Template to import the quiz questions into Brightspace.
Some of these questions include quotation marks and we realised that when the quotation marks were copied from the word doc file, there's a difference in the quotation marks “” copied from word (orange cell) as compared to the quotation marks "" written out in excel (see the green cell).
The quotation marks “” (in the orange cell) would show up in Brightspace as these icons �, which is incorrect.
To get around this, the only way I've thought of so far is to simply and painstakingly identify the quotation marks and manually retype each quotation mark in excel. Excel is not able to find and replace the “” quotation marks, and copying and pasting as plain text does not convert the quotation marks as well.
Thus, this brings about my question - Why are the Quotation marks in Microsoft Word different from the one in .csv?
And is there any advice for me to ensure that the quotation marks copied into excel gets read properly in Brightspace?
Thank you!