Whenever we prepare any report in excel, we have two constituents in any report.
The Text portion and the Numerical portion.
But just storing the text and numbers doesn’t make the super reports. Many times we need to automate the process in the reports to minimize the effort and improve the accuracy.
Many functions are provided by the Excel which work on Text and give us the useful output as well. But few problems are still left on which we need to apply some tricks with the available tools.
We are going to learn many tricks and usage of function to perform different operations on the TEXT IN EXCEL.
In this article, we are going to learn how to combine text in excel.
Combining the text is required many times in the automation process of our reports.
TEXT IS AN INACTIVE NUMBER TYPE[FORMAT] IN EXCEL. ANYTHING STORED AS TEXT [NUMBER OR DATE] WON’T RESPOND TO ANY STANDARD FORMULAS OR FUNCTIONS BUT SPECIALLY DESIGNED TEXT FUNCTIONS. [EXCEPTIONS DO OCCUR IN CASE OF NUMBERS]
Combining text is excel is very useful technique.
Let us understand what we mean by combining the text.
The combining means to stick the text to one another. For example if one cell is having “ABCD” and the other is having the value as “EFGH”. If we combine them in the third cell the result will be “ABCDEFGH”.
The specific term used for sticking the text or combining the text or joining the text in the computer language is CONCATENATE which simply means to stick or append.
We can join the text in Excel in many ways.
The difference between CONCAT FUNCTION and CONCATENATE FUNCTION is that CONCAT function can accept a complete Range of cells to act upon for example If we want to concatenate the cells from A1 to A5 we can simply write CONCAT(A1:A5).
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE