First, connect the cell contents.

= a 1 & amp； B 1

Use & combines the contents of two cells, and of course, the combination of multiple cells is similar.

Second, the connection between text and time

B2 & amp； Text (A2, "Height: mm: sec")

Text is associated with a time or date. If you connect directly, the time and date will become numbers. We need to use the text function to convert the date or time into text, and then use the&; Connect.

Third, the format is inconsistent to find.

The code in D2 is a number, while the code in the source data is a text. If you use vlookup function directly, there will be an error. What should I do? We can convert the numerical value into text and look it up directly.

E2 = VLOOKUP(D2 & amp； ，A:B，2，0)

Formula explanation:&; Yes, directly convert the D2 value into text, and then look it up.

Connector introduction

Connectors are also called "join operators". As far as programming languages are concerned, there is a "string concatenation operator" whose function is to merge two strings into one.

Categories in categories

word

Buttons and Options Bar. To display the toolbar, press Alt, and then press Shift+F 10. , click AutoShape, point to Line, and then click the line style you want.

Drag to draw a line.

Please do one or both of the following:

To constrain the line to all directions from the starting point and then draw at an angle of 15 degrees, hold down Shift while dragging.

To extend a straight line from the first endpoint in two opposite directions, hold down the Ctrl key while dragging.

Server-side programming language (abbreviation of professional hypertext preprocessor)

Equivalent to string operations in other languages+such as echo“hello ". "the world"; Equivalent to echo "hello"+"world"; In the same way. = is also the same as+=.