If strings are not separated by “, “ (i.e. The output of the function returns as a combined string in new cell.įunction should give output in “General” format, however if output is not as per the desired format then we need to change the cell format to “GENERAL”.ĬONCATENATE Function has argument called “ text”, where we need to give the cell references, we can give multiple cell references as per the requirement to combine by following the “, “ (i.e. We will be learning the Microsoft Excel “CONCATENATE” in details, so stay with us and continue reading…ĬONCATENATE function is used for combining two or more Microsoft Excel strings into one.
In the said scenario “CONCATENATE” function will help you to find the solution. While working with Microsoft Excel, did you get a situation to combined multiple strings into one? I believe most of your answers are YES. How to use “CONCATENATE” function in Excel
0 kommentar(er)
