You can combine two text cells in Excel using the TEXTJOIN function. No matter whether you want to join two or more than two cells, you can use this function to get the job done.

CONCATENATE, an Excel function used to join various text strings into one, is available in Excel 2007 and later versions. The syntax for the CONCATENATE function is CONCATENATE(text1, [text2], …), ...

Excel’s Text functions are a major time saver if your job entails managing massive data, especially data that’s imported from other sources. Fortunately, all ASCII data is easily imported, but ...