Hướng dẫn cách sắp xếp tên theo thứ tự ABC trong Excel

Hello everyone, today we have a pretty cool db This is a list of company employees And the request is that we have to do it according to the rules of the trust So, how do we do it quickly? First, we have to do this db in two steps The first step is that we separate them into a group And the first column is a column After we follow the project to separate the first column Then it will complete the db Now let's get started First we will click on the right column We create a column This column will be the first column And I will copy the origin Copy the origin of the name and the name I will copy this part here And I will copy this part of the name After that, I will go to the part called the heart I will choose a heart and replace it Here, if you use English, you can use the hexadecimal symbol Here I will use the hexadecimal symbol And replace by a decimal I will keep this column I will replace everyone OK, now we see it We have our own column Next, we will separate the group and column I'll create a column I have to write the letter H and the date The date is the date To separate the letter H and the date, we have to use a dictionary Now I will call the formula and I will explain to you The formula is as follows Bang, Re, Lep What is this Lep? B3, Q7, Ln, M3, B3, D4, Ln, M3, B3 I will explain this formula to you Lep is the decimal point on the left hand side According to the dictionary, the letter H and the date are equal to the letter H and the date The date is the date, right? The price is the price, right? We understand the dictionary like this In the formula, we will use Lep, which is the decimal point on the left hand side The price is the price of the letter H and the date After we apply the formula correctly, we enter the right mouse button Move to the black mouse button You press the right mouse button twice Excel will apply the formula for the remaining codes You can see this Le Dinh Quoc Van Le Dinh Quoc Van is right Le Dinh Quoc Van is separated here Now we will temporarily hide the letter H and the date So now we have separated the letter H and the date Now we will arrange the code According to the alphabet formula To arrange the code according to the alphabet formula What do you do? You go to the data column Then go to the arrangement column Or if you use English You will go to the data column Then go to the short column You just need to press the button with the letter A You can choose the part of A to Z We will arrange according to the alphabet formula And the software asks if there are 10 columns We enter 10 columns We choose to arrange When we choose to arrange You will see that the column has been arranged The alphabet formula ABC But you see a problem The problem with the 4th column The 4th column is like this You can delete it