![]() For example, when you paste the "š" in the Visual Basic, you may get "?". (1) Your Microsoft Visual Basic may not recognize accented characters at all, if it does not support Unicode. Then go to a blank cell and paste the formula in a cell: =CheckStringCHAR(InString), for example =CheckStringCHAR("ù"), or =CheckStringCHAR(A2). Click Insert > Module, and paste the following macro in the Module Window. ![]() Hold down the Alt + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.Ģ. For users who are experienced with Microsoft Excel, using VBA macro is an easy way to deal with this complicated work.ġ.
0 Comments
Leave a Reply. |