Description

CONCAT is a text function in Excel. It’s an improved version of CONCATENATE and was introduced in place of CONCATENATE after removing it’s limitations. CONCAT accepts all kind of range, cell references or text strings, either individually or in combination with each other

Syntax

CONCAT(text1, [text2],…)

Example

You can select a range in CONCAT Excel function to join the text.
You can use combination of all a range, a cell reference and text in CONCAT Excel function

0 Comments

By Rajesh K Saraogi

Rajesh is a hardcore finance person with a penchant for latest technology. His passions are latest technology and to improve the productivity with simple, yet powerful software – mainly on Microsoft Excel platform. He is a qualified MCA. Whenever he gets time he loves to blog, to share the knowledge, which is the only thing which increases after sharing!

Text Functions