48. Excel Tips - Add 2 strings together in Excel
Adding 2 strings together is very easy in Excel.
There are a couple of ways.
Method1: use: &" "& NOTE - this adds a space between the 2 strings Here's an example:
Method2: use CONCATENATE
If the CONCATENATE function were designed properly, it would allow you to enter a range instead of each value separately, and it would allow you also to enter a separator.
Consequently, I prefer Method1.
Video Training on Adding 2 strings together in Excel: