**Concatenation** is one of the most common ways to **join texts** and numbers in Excel. This process can make the whole process of joining multiple texts with numbers with decimals effortless. If you are curious to know how you can concatenate decimal places in Excel, then this article may come in handy for you. In this article, we will discuss how you can concatenate decimal places in Excel with elaborate explanations.

**Table of Contents**hide

## Download Practice Workbook

Download this practice workbook below.

## 5 Suitable Examples to Concatenate Decimal Places in Excel

Here we are going to present 5 suitable examples to concatenate decimal places in Excel combining various types of functions. The dataset that we are going to use is simple fruit names with their unit price value. For avoiding any types of compatibility issues, try to use the **Excel 365** edition.

### 1. Concatenate with Two Decimal Places

**Concatenation of numbers** with two decimal places is going to be shown here with the help of **CONCATENATE **and **ROUND** functions.

**Steps**

- To join or
**concatenate the text and the number**, select cell**D5**and enter the following formula:

`=CONCATENATE("The Unit price of the ",B5," is ","$",ROUND(C5,2))`

**Formula Breakdown**

**CONCATENATE(“The Unit price of the “,B5,”is “,”$”,ROUND(C5,2)): **This function will concatenate or join the text mentioned in the first argument, proceeded with joining the text mentioned in the cell **B5 **with the decimal number mentioned in cell **C5** in the last argument. After then we will have the texts joined with the decimal numbers.

- Then drag the
**Fill Handle**to cell**D7**. - We will notice that the range of cell
**D5:D7**is now filled with concatenated fruit names with their decimal prices.

**Read More: ****How to Concatenate Two Columns in Excel (2 Suitable Methods)**

### 2. Concatenate Without Losing Decimal Places

Using **the TEXT function**, we can fix decimal numbers rounding limit. Then we can easily concatenate them using an ampersand sign. There will be no loss of decimal places in this procedure.

**Steps**

- To join or concatenate the text and the number with decimals, select cell
**D5**and enter the following formula:

`="The Unit price of the "&B5&" is "&"$"&TEXT(C5,"0.000")`

- Then drag the
**Fill Handle**to cell**D7**. - We will notice that the range of cells
**D5:D7**is now filled with concatenated fruit names with their decimal prices.

**Read More: ****How to Concatenate Multiple Cells in Excel (7 Easy Ways)**

**Similar Readings**

**How to Concatenate String and Integer with VBA (5 Ways)****Combine Date and Text in Excel (5 Ways)****How to Concatenate with Space in Excel (3 Suitable Ways)****Combine Multiple Columns into One Column in Excel****How to Add a 1 in Front of Numbers in Excel (7 Easy Ways)**

### 3. Concatenating with TEXT Function

Using **the TEXT function**, we can fix decimal numbers rounding limit. Then we can easily concatenate them using an ampersand sign.

**Steps**

- To join or concatenate the text and the number with decimals, select cell
**D5**and enter the following formula:

`="The Unit price of the "&B5&" is "&"$"&TEXT(C5,"0.00")`

- Then drag the
**Fill Handle**to cell**D7**. - We will notice that the range of cells
**D5:D7**is now filled with concatenated fruit names with their decimal prices.

**Read More: ****How to Concatenate and Keep Currency Format in Excel (3 Methods)**

### 4. Using ROUND Function

Using **the ROUND function**, we can fix decimal numbers’ rounding limit. Then we can easily concatenate them using an ampersand sign.

**Steps**

- To join or concatenate the text and the number with decimals, select cell
**D5**and enter the following formula:

`="The Unit price of the "&B5&" is "&"$"& ROUND(C5,2)`

- Then drag the
**Fill Handle**to cell**D7**. - We will notice that the range of cells
**D5:D7**is now filled with concatenated fruit names with their decimal prices.

**Read More: ****How to Combine Rows into One Cell in Excel**

### 5. Combining CONCATENATE and FIXED Functions

Using the combination of **FIXED** and **CONCATENATE**, we will join or concatenate multiple text and numbers with decimals.

**Steps**

- To join or concatenate the text and the number with decimals, select cell
**D5**and enter the following formula:

`=CONCATENATE("The Unit price of the ",B5,"is ","$",FIXED(C5,2))`

**Formula Breakdown**

**FIXED(C5,2):**This**FIXED**function will fix the rounding of the number mentioned in the first argument. The rounding of the numbers depends upon the second argument.**CONCATENATE(“The Unit price of the “,B5,”is “,”$”,FIXED(C5,2)):**This function will concatenate or join the text mentioned in the first argument, proceeded with joining the decimal number mentioned in the second argument.

- Then drag the
**Fill Handle**to cell**D7**. - We will notice that the range of cells
**D5:D7**is now filled with concatenated fruit names with their decimal prices.

**Read More: ****Combine CONCATENATE & TRANSPOSE Functions in Excel**

## Conclusion

To sum it up, the issue of how you can concatenate decimal places in Excel is here with 5 separate examples.

For this problem, a workbook is available to download where you can practice these methods.

Feel free to ask any questions or feedback through the comment section. Any suggestion for the betterment of the **Exceldemy **community will be highly appreciable.

## Related Articles

**How to Concatenate with Delimiter in Excel (5 Easy Ways)****CONCATENATE vs CONCAT in Excel (2 Ideal Examples)****How to Concatenate and Keep Number Format in Excel****Concatenate Multiple Cells with Comma in Excel (4 Ways)****How to Bold Text in Concatenate Formula in Excel (2 Methods)****Concatenate Multiple Cells but Ignore Blanks in Excel (5 Ways)****How to Concatenate String and Variable in Excel VBA (A Detailed Analysis)**