CONCAT formula in excel with example || Part-02 || Join cells value together
In our last video, we have discussed CONCATENATE formula. we have seen there was many limitation like not possible to select cell ranges and more than 30 cells is not allowed. Today we will discuss about CONCAT formula which is the replacement of CONCATENATE formula.
Like CONCATENATE function, The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide delimiter or IgnoreEmpty arguments.
Syntax
=CONCAT( text1, [ text2, ... text_n ] )
In our next tutorial we will discuss about MOST amazing formula TEXTJOIN.
============================================================
Sharing is caring !!! Your responses will inspire me to upload more tutorial.💪💪
So...Share 🤝 || Like 👍 || Comment ✍️
👉 Our all youtube video:- https://www.youtube.com/c/mmbcampus?s...
👉 Excel VBA all video:- • How to use "IF, ElseIf, Else" in Exce...
👉 Excel Formula all video:- • How to write Microsoft Excel Formula,...
👉 Ask your any question in facebook page / mmbcampus2016
👉 Visit https://www.mmbcampus.com to download all related file, if any.
===========================================================
Link you may like:-
CONCATENATE formula in excel with example || Part-01 || Join cells value together. • CONCATENATE formula in excel with exa...
TEXTJOIN formula in Excel with many example || Part-03 || Join cells value by space, comma etc. • TEXTJOIN formula in Excel with many e...
Comparison of CONCATENATE, CONCAT and TEXTJOIN formula in excel || Part-04
• Comparison of CONCATENATE, CONCAT and...
Watch video CONCAT formula in excel with example || Part-02 || Join cells value together online without registration, duration hours minute second in high quality. This video was added by user mmb campus 25 October 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1 once and liked it people.