Merge text in Excel

In Excel we like to store the names, first names and address details in separate columns. Yet there will always come a day when you want to merge the information from various columns. There are several ways to combine data in a smart way.