How to Remove Chinese Text from Cells in Excel?

Date:2022-4-16 Author:Sandra

In our today’s tutorial, we would like to talk about how to delete Chinese text from worksheets in Excel. Actually, you can solve this with VBA code. But most people are not familiar with this. So, let’s use the easiest way to handle it. It only needs three steps to finish.

Step 1: Copy and Paste.

These Chinese texts can’t be directly removed in Excel. So, we need to copy and paste them into a Word document.

How to Remove Chinese Text from Cells in Excel?
How to Remove Chinese Text from Cells in Excel?

Step 2: Replace Them.

Press Ctrl + H to quickly open the Find and Replace window.

Enter [!^1-^127] in the Find what box.

How to Remove Chinese Text from Cells in Excel?

Then click More to check the checkbox of Use wildcards. Then hit Replace All.

How to Remove Chinese Text from Cells in Excel?
How to Remove Chinese Text from Cells in Excel?

Step 3: Copy and Paste

After the replacement, copy these English texts and paste them back into the Excel worksheet.

How to Remove Chinese Text from Cells in Excel?
How to Remove Chinese Text from Cells in Excel?

Got it? That’s so easy. Hope this can be helpful to you.

How to Remove Chinese Text from Cells in Excel?

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *