Home  >  Article  >  Topics  >  Practical Word skills sharing: organize information and turn messy ID cards into order

Practical Word skills sharing: organize information and turn messy ID cards into order

青灯夜游
青灯夜游forward
2022-04-01 10:55:098091browse

Word As the most frequently used software in the workplace, many seemingly simple and inconspicuous skills can be of great help at critical moments, saying goodbye to overtime work. Starting today, I will share with you some tips on using Word. This article will share with you how to organize messy ID card information and make it tidy. I hope it will be helpful to you!

Practical Word skills sharing: organize information and turn messy ID cards into order

The following is a weird employee information table:

Practical Word skills sharing: organize information and turn messy ID cards into order

Look, there are so many cells that I can’t bear to use, all of them The data is all squeezed into one cell. This is the rhythm of using Excel as Word. Is it blocked?

Now we need to organize this information, with names and ID numbers in separate columns. Think about it, what should we do?

1. Create a new Word document

Since you use Excel as Word, you need to ask Word to help.

First create a new Word document, copy the content in Excel, and paste it into the Word document.

2. Bring up the replacement dialog box

Press Ctrl H to bring up the replacement dialog box and set as shown below.

【Search content】Enter <span style="color: rgb(255, 0, 0);">[0-9X]{1,}</span>

[0-9X] It means any number and the letter X. {1,} represents a string of more than one character.

Together, it is to search for a string of more than one character consisting of any number and the letter X, which is the ID number.

【Replace with】Enter <span style="color: rgb(255, 0, 0);">^t^&^p</span>

##^t is the tab character, ^& represents the character to be searched for, and whatever it is searched for represents. ^p is a newline character.

To put it all together is to add tab characters and names in front of all the ID numbers to be searched, and add line breaks after them, so that each group of names and ID cards is on a separate line.

Click the [More] button and check [Use Wildcards].

Click [Replace All]

Practical Word skills sharing: organize information and turn messy ID cards into order

The effect after replacement:

Practical Word skills sharing: organize information and turn messy ID cards into order

3 , Set cell format

In Excel, first select the two column labels used to store data, and set the cell format to text.

Practical Word skills sharing: organize information and turn messy ID cards into order

Return to Word, press Ctrl A to select all content. Press Ctrl C again to copy.

Go back to Excel, right-click cell B1, and select [Match target format] in the paste options.

Practical Word skills sharing: organize information and turn messy ID cards into order

4. The finished effect

Practical Word skills sharing: organize information and turn messy ID cards into order

Recommended tutorial: "

Word Tutorial

The above is the detailed content of Practical Word skills sharing: organize information and turn messy ID cards into order. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:excelhome.net. If there is any infringement, please contact admin@php.cn delete