Excel connection function usage example

Source: Internet
Author: User

What is the CONCATENATE function?

Syntax

CONCATENATE (text1, text2 ,...)

Text1, text2,... is one to 30 text items to be merged into a single text item. These text items can be text strings, numbers, or references to a single cell.

Description

You can also use the & (and) operator instead of the CONCATENATE function to merge text items.

Use the & operator instead of the CONCATENATE function to merge text items. For example, the result of formula = "Zhang" & "Jun" is "Zhang Jun ".
 

Function usage

Assume that cells A2 and ET2 are the strings to be connected (150), enter: = A2 & "&" & B2 in A3, and enter: = A3 & "&" & C2: Select B3 and point the mouse pointer to the bottom right corner of cell B3. When the mouse pointer turns to a black solid line plus sign, pull it to the right, drag the ES3 cell (the previous column of the last string), copy the ES3 cell, click the cell you want to put the result, right-click it, and choose paste> value> OK.

Example

First, it is the concatenate function. As shown in the figure, you need to connect the name and age by adding the two.

What should I do if I need to add a-sign between my name and age and add a year after my age? As shown in the figure, click the fx symbol

As shown in the figure, enter the desired content in sequence.

Complete the task, as shown in the following figure.

There is also a function that can be used to connect to the phonetic function, as shown in the figure, directly select the target region.

However, you will find that the last one I love Baidu 666 does not show the number 666. Why? In fact, this function can only connect characters and cannot connect arrays. It will automatically ignore numbers. Advantages and disadvantages: select a suitable connection function application.

Example 2

Example:

1. Assume that the preceding text needs to be entered in column C of a sheet 1 worksheet of a certain Workbook, in the two cells A1 and B1 in the Sheet2 worksheet, enter the different sections of the text, "XX city" and "building and installation engineering company ",

2. Enter the formula = CONCATENATE (Sheet2! $ A $1, D1, Sheet2! $ B $1 ).

3. If we enter "ninth" in cell D1, cell C1 will automatically fill in the text "ninth Construction and Installation Engineering Company of XX city ".

4. Copy the formula of cell C1 to other cells in column C, and enter different parts of the text in other cells in column D.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.