Shulou(Shulou.com)06/01 Report--

How to skillfully use string concatenation in Excel skills, aiming at this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

There is a basic formula in Excel to concatenate strings in several cells.

For example, in the above example, strings are concatenated in A1 A1&B1&C1 B1 C1 cell, as long as you type = string in D1 cell.

Let's start using the string concatenation feature.

Example 1: examination score statistics

Suppose we have the following test score data

It is hoped that the number of people can be calculated according to address and age.

Of course, there are many ways to do this statistics, but we only introduce the method of using connection strings here.

We can join the contents of column B and column C by entering = B10&C10 in the E10 cell.

And then start counting.

Let's first enter the following formula in the C25 cell.

= COUNTIF ($Eternal 10 Epist21 recording A25 million Craft 23)

A brief description:

First concatenate A25 and C23 to get the string [Shahekou 17], then look for the string in the E10:E21 range and count it. The result is 0.

Then copy this formula to other cells, and you can calculate other results.

Example 2: test result statistics

Whether it is software or hardware, even a part needs to be tested. There are successes and failures in tests. You need to retest when you fail.

The test report could look like this.

The difficulty of this is that there are many intermediate results of the tests. The only one that needs statistics is the one on the far right.

The answer is already there. We first enter it in the G2 cell.

= RIGHT (B2B2C2D2E2F2Magne2)

This formula does the following two things.

Connect B2 to F2

Take the two letters to the right of the result string.

In this way, no matter how many tests there are, you can always get the results of the last test.

All that is left is to copy this formula to all the cells in column G to get the final result of each test project.

This is the answer to the question about how to skillfully use string concatenation in Excel skills. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.