How to Use Concatenate Formula in Excel
How to Use Concatenate Formula in Excel Urdu / Hindi
We can join text using Concatenate, Concat and TextJoin function in Excel.
Although CONCAT and TEXTJOIN functions are available only in Office 2019 & Office 365 versions.
Let's have a look at the syntax and arguments of the functions:
CONCATENATE:
Use CONCATENATE, one of the text functions, to join two or more text strings into one string.
Syntax:
CONCATENATE(text1, [text2], ...) text1 (required)
The first item to join. The item can be a text value, number, or cell reference. Text2, ... (optional) Additional text items to join. You can have up to 255 items, up to a total of 8,192 characters. CONCAT: This function replaces the CONCATENATE function.
However, the CONCATENATE function will stay available for compatibility with earlier versions of Excel.
The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments. Syntax: CONCAT(text1, [text2],…) text1 (required) Text item to be joined.
A string, or array of strings, such as a range of cells. [text2, ...] (optional) Additional text items to be joined. There can be a maximum of 253 text arguments for the text items. Each can be a string, or array of strings, such as a range of cells.
TEXTJOIN: The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges. Syntax: TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) delimiter (required) A text string, either empty, or one or more characters enclosed by double quotes, or a reference to a valid text string. If a number is supplied, it will be treated as text. ignore_empty (required) If TRUE, ignores empty cells. text1 (required) Text item to be joined. A text string, or array of strings, such as a range of cells. [text2, ...] (optional) Additional text items to be joined. There can be a maximum of 252 text arguments for the text items, including text1. Each can be a text string, or array of strings, such as a range of cells. For more such videos subscribe to our channel