Normally, in Microsoft Excel, you can organize and split share data easily. It is a formula and a lot of features that can be managed The data well. And some data and some data On the other hand, if the data is And you want to split or make it separate from each other Between the name and the Family How do you apply? Type the name of the Prepare a separate name and Family? If more How do you type the resistance of all?
When you do not need difficult to retype the name, we will show the method and formula In those organized separately between the Family and easily implemented The following way:
1. The first, you need to log in to your Microsoft Excel data and Family. Make sure that Family Or easy to set formula to Family or download separate.
2. Then you need to set the Family or in front of or behind. In this example, I put the Family in front of a Chheang Vuthea, Hut Samnang. The
n you have to type this formula want to. This formula shows that the LEFT is available for download on the left, which we define as the Family ambanhminh., And at the SEARCH ("") ("), you need space to apply. But if you do not have spaces It can only display text only.
You can see in the picture.
3. Then you will get the following results:
4. You need to set again This formula
= RIGHT (NN, LEN (NN)-SEARCH ("", NN)), and you need to change the NN by the Cell. RIGHT download on the right, which we define as the name., you can see the following:
5., You will get the following results:
In the end, you will receive The result is better distinguish between names and Family Easily. On the other hand, Make sure to use it, do not call at any particular time.
