Two Tips For Data Management In Excel

Date:2022-2-15 Author:Sandra

My cousin Nancy is learning Chinese recently.  So she put together an Excel worksheet and prepared to print it out to study.

 Oh, I guess Nancy is not learning Chinese, but falling in love with some Chinese guy. 

Ok, let’s return to the subject.

Tip No.1 How to adjust the order of English and Chinese?

Two Tips For Data Management In Excel

Actually, it’s very easy.

Just Enter =A2 in cell B1, and Enter =A1 in cell B2, then double-click the fill handle.

Two Tips For Data Management In Excel

Tip No.2 How to put English and Chinese in different columns?

Enter A2&”” in cell B2 and A4&”” in cell B3, then both fill to right.

Two Tips For Data Management In Excel

Select the area and double-click the fill handle.

Two Tips For Data Management In Excel

Now, we need to choose columns B and C to press Ctrl and H to quickly open up the Find and Replace. Replace all the A into =A.

Two Tips For Data Management In Excel

Now all the replacements are done.

Two Tips For Data Management In Excel
Two Tips For Data Management In Excel

That’s quite easy and useful.

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 *