How to use the CONCATENATE function in Excel
If you want to join multiple texts, numbers or function values into one cell, Excel has a function called CONCATENATE(). You can use the function is some very creative ways. Simple text concatenation The CONCATENATE function works like this: = CONCATENATE( text1, text2, text3). In the example below, text1 in in A1 cell, text2 is a space (if you specify text you have to put it in quotes) and text3 is in cell B1. Addind Good, a space and Morning will result in "Good Morning" Concatenate text with numbers Concatenate works with text and numbers just as well. The...read more