Remove Foreign Language Characters

Link to full course: https://commercecurve.com/ultimate-excel-training/ When working for a Multinational Company, there are instances where Excel reports are shared that contain both English and foreign language text. You are often required to remove the foreign text if you want to further work on these Excel files. To do that, you have to manually select each cell and remove the foreign text to be able to use the reports. This makes the whole process lengthy. We can remove the foreign text using the VBA code provided below. We have also provided explanation of what the code Syntax means and how the Excel uses the code to differentiate between English and Foreign language text. We will work on a sample file to show the results of the code. We are using a sample Chinese menu containing both English and Chinese Text and we want the sheet to be updated to show only the English Text.