Home > Software engineering >  [for] of special symbols in VBA read the word, the data into Excel, special symbols can not display
[for] of special symbols in VBA read the word, the data into Excel, special symbols can not display

Time:09-16


As shown, the contents of the need to Word document, imported into excel

The largest candy is encountered, special symbols!!!!!!!!!!!!!!!! The problem of
Both of the special symbols, read after the entry of excel, become (
So, it is embarrassing to respectively which is checked item

This word there are tens of thousands of need, a little worry
Said Google for a few days to find a foreigner in VBE varies does not support Unicode, have who can solve this problem?

Word and Excel files and code in this tiny cloud address
https://share.weiyun.com/5f4DbJx

CodePudding user response:

Science to the Internet, go to the foreigner website questions
Results says not to be outside the chain, put my account to seal, drunk

CodePudding user response:

Can have a try with regular replacement.
  •  Tags:  
  • VBA
  • Related