How to Concatenate and Keep Formatting in Excel

Concatenating cells in Excel is a common task, but what if you want to keep the formatting of the original cells? For example, if you have a column of numbers that are formatted as currency, and you want to concatenate them into a single cell, you would normally lose the currency formatting.

There is a simple way to concatenate cells and keep the formatting of the original cells. You can use the TEXTJOIN function.

The TEXTJOIN Function

The TEXTJOIN function is a new function in Excel that was introduced in Excel 2016. It allows you to concatenate cells and specify a delimiter between the cells.

The syntax of the TEXTJOIN function is as follows:

“`
=TEXTJOIN(delimiter, ignore_empty, text1, text2, …)
“`

delimiter is the character that you want to use to separate the cells.
ignore_empty is a logical value that specifies whether or not to ignore empty cells.
text1, text2, … are the cells that you want to concatenate.

Example

To concatenate cells and keep the formatting of the original cells, you can use the following steps:

1. Select the cells that you want to concatenate.
2. Click on the “Insert” tab.
3. Click on the “Function” button.
4. Select the “TEXTJOIN” function.
5. In the “Delimiter” field, enter the character that you want to use to separate the cells.
6. In the “Ignore_empty” field, select “FALSE”.
7. In the “Text1” field, enter the first cell that you want to concatenate.
8. In the “Text2” field, enter the second cell that you want to concatenate.
9. Continue adding cells to the TEXTJOIN function until you have added all of the cells that you want to concatenate.
10. Click on the “OK” button.

The TEXTJOIN function will concatenate the cells and keep the formatting of the original cells.

Conclusion

The TEXTJOIN function is a powerful tool that can be used to concatenate cells and keep the formatting of the original cells. This can be useful for a variety of tasks, such as creating reports and presentations.

Also Read: Where Are The Mounting Holes On A Panasonic Viera

Recommend: Do You Use Commas With And

Related Posts: How Diazonium Salts Are Prepared

Also Read: What Height Should A Zimmer Frame Be

Recommend: How To Get Ombre Hair On Bitmoji