I am retrieving data from word tables and on some of the cells, excel is dropping the hyphen. For example, in word, the data cell is:
MCC‑65‑4A M‑1332 ( Drive
In Excel the data becomes:
MCC654A M1332 (Drive Room) MLP
It doesn't do it on everything. Any ideas? Below is the...