In Microsoft Excel, there are numerous ways available to concatenate or join numbers to display in a single cell. The numbers can be of different formats and thatâ€™s why we have to insert an additional function to specify the formats of the numbers while combining them. In this article, youâ€™ll find all possible methods and formulas to concatenate numbers with simple examples and proper illustrations.

**Table of Contents**hide

**1. Concatenating Numeric Values in Excel**

In our first example, weâ€™ll show how to concatenate simple numerical values in Excel. In the following picture, two values are lying in** B5 and C5**.

In the output box, weâ€™ll combine these numerical values by adding a conjunction â€˜andâ€™ between them. Weâ€™ll use **Ampersand (&)**, **TEXTJOIN, CONCATENATE** and **CONCAT **functions separately to generate the outputs. The related formulas will be shown under the **Formulas **header for the corresponding outputs.

The output cells ranging from **B8 to B11** occupy the following successive formulas:

With the use of **Ampersand (&)** only:

`=B5&" and "&C5`

With the **CONCATENATE **function:

`=CONCATENATE(B5," and ",C5)`

With the **CONCAT **function:

`=CONCAT(B5," and ",C5)`

And with the **TEXTJOIN **function:

`=TEXTJOIN(" and ",TRUE,B5,C5)`

**2. Concatenating Fraction Numbers in Excel**

Now weâ€™ll concatenate two fraction numbers with the conjunction **â€˜andâ€™**. Weâ€™ll have to use **the TEXT function** here to specify and maintain the format of the fractions.

With the uses of the **TEXT **function and **Ampersand (&)**, the formula used in **Cell B8** is:

`=TEXT(B5,"#/#")&" and "&TEXT(C5,"# 0/0")`

With the use of **CONCATENATE **function:

`=CONCATENATE(TEXT(B5,"#/#")," and ",TEXT(C5,"# 0/0"))`

With the use of **CONCAT **function:

`=CONCAT(TEXT(B5,"#/#")," and ",TEXT(C5,"# 0/0"))`

And with the use of **TEXTJOIN **function:

`=TEXTJOIN(" and ",TRUE,TEXT(B5,"#/#"),TEXT(C5,"# 0/0"))`

**3. Joining Dates and Times in Excel**

In this section, weâ€™ll now concatenate a date and a time. Again we have to use the **TEXT **function here to specify the formats of the date and time. Otherwise, the dates and times will show their corresponding serial numbers only that are assigned in Excel.

Weâ€™ll again use four types of formulas here to concatenate date and time. The date and the time will be separated by a **comma **(**,**). The formulas that can be used to combine the date and the time are as follows.

With the combination of **Ampersand (&)** and the **TEXT **function only, the formula will be:

`=TEXT(B5,"DD-MM-YYYY")&", "&TEXT(C5,"HH:MM:SS AM/PM")`

With the uses of **CONCATENATE **and **CONCAT **functions:

`=CONCATENATE(TEXT(B5,"DD-MM-YYYY"),", ",TEXT(C5,"HH:MM:SS AM/PM"))`

**Or,**

`=CONCAT(TEXT(B5,"DD-MM-YYYY"),", ",TEXT(C5,"HH:MM:SS AM/PM"))`

And with the application of the **TEXTJOIN **function:

`=TEXTJOIN(", ",TRUE,TEXT(B5,"DD-MM-YYYY"),TEXT(C5,"HH:MM:SS AM/PM"))`

**4. Concatenating Currency Values in Excel**

Now weâ€™ll concatenate two currencies with the conjunction **â€˜andâ€™**. As the currency values are in dollars, weâ€™ll have to use the **TEXT **function to specify the format of the amounts as well as the symbol of the dollar ($).

With the use of **Ampersand (&)** and **TEXT** function, the required formula in the first output **Cell B8** will be:

`=TEXT(B5,"$ 0,000.00")&" and "&TEXT(C5,"$ 0,000.00")`

With the uses of **CONCATENATE **or **CONCAT **function:

`=CONCATENATE(TEXT(B5,"$ 0,000.00")," and ",TEXT(C5,"$ 0,000.00"))`

**Or,**

`=CONCAT(TEXT(B5,"$ 0,000.00")," and ",TEXT(C5,"$ 0,000.00"))`

And with the application of the **TEXTJOIN **function, the formula is as follows:

`=TEXTJOIN(" and ",TRUE,TEXT(B5,"$ 0,000.00"),TEXT(C5,"$ 0,000.00"))`

The resultant data are visible under the **Output **header in **Column B**.

**Read More:** How to Concatenate and Keep Currency Format in Excel

**5. Combining Percentage Numbers in Excel**

To concatenate two percentage values, we have to again specify the format of the numeric values and the percentage symbol (%) with the **TEXT **function. The procedure is the same as described in the previous method where we had to define the dollar symbol and the format of the numeric amounts.

With the uses of **Ampersand (&)** and other related functions, the required formulas as follows have led to similar results under the **Output **header in **Column B**:

`=TEXT(B5,"00.00 %")&" and "&TEXT(C5,"00.00 %")`

With the uses of **CONCATENATE **or **CONCAT **function:

`=CONCATENATE(TEXT(B5,"00.00 %")," and ",TEXT(C5,"00.00 %"))`

**Or,**

`=CONCAT(TEXT(B5,"00.00 %")&" and "&TEXT(C5,"00.00 %"))`

And by applying the **TEXTJOIN **function:

`=TEXTJOIN(" and ",TRUE,TEXT(B5,"00.00 %"),TEXT(C5,"00.00 %"))`

**6. Concatenating Numbers Formatted as Scientific Notations**

In our last example, weâ€™ll combine two scientific numbers that include exponents. The numbers are lying in **B5 **and **C5**.

With the use of the **TEXT **function, we have to specify the formats of the scientific notations. By using **Ampersand (&)** and the **TEXT **function, the required formula should be as follows:

`=TEXT(B5,"0.00E+00")&" and "&TEXT(C5,"0.00E+00")`

Applying the **CONCATENATE **or **CONCAT **function will construct the following formulas:

`=CONCATENATE(TEXT(B5,"0.00E+00")," and ",TEXT(C5,"0.00E+00"))`

**Or,**

`=CONCAT(TEXT(B5,"0.00E+00")," and ",TEXT(C5,"0.00E+00"))`

And with the use of the **TEXTJOIN **function, the related formula will be:

`=TEXTJOIN(" and ",TRUE,TEXT(B5,"0.00E+00"),TEXT(C5,"0.00E+00"))`

**Download Practice Workbook**

You can download the Excel workbook that weâ€™ve used to prepare this article.

**Concluding Words**

I hope all of the formulas and procedures mentioned above will now help you to apply them in your Excel spreadsheets when you have to concatenate numbers. If you have any questions or feedback, please let me know in the comment section. Or you can check out our other articles related to Excel functions on this website.

## Related Articles

- How to Combine Text and Number in Excel
- How to Add a 1 in Front of Numbers in Excel
- How to Concatenate Numbers with Leading Zeros in Excel
- How to Add Leading Zeros in Excel by CONCATENATE Operation
- How to Concatenate and Keep Number Format in Excel
- How to Concatenate Date That Doesnâ€™t Become Number in Excel
- How to Combine Date and Text in Excel
- How to Combine Text and Numbers in Excel and Keep Formatting