What does Excel & "" mean

What does Excel & mean? In particular, it is common to filter formulas.

Let's take a look at a basic usage, A1 cell is empty cell, do not enter any content, B1 cell enter =A1, carriage return, returned result: 0. The input =a1& "" returns empty text.

After reading the explanations above, you will understand what Excel & "" means.

,& is the text merge operator in an Excel formula, "" is empty text, Formula & ": Represents the result of the formula's operation being merged with empty text.

The filter formula uses this feature to replace a formula error value that does not satisfy a condition by using it in a formula that returns a result in a conditional filter.

As the following illustration shows, the Excel formula uses & "", and when the formula is pulled down and there is no data that satisfies the condition, the empty empty cell text appears.

Let's take a look at the end of the Excel formula without using & "", when the formula is pulled down, there is no data to meet the criteria, show 0, affect the visual effects.

With the above explanation, you should understand what Excel & "" means.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join