The Excel Function of the month is
CONCATENATE
Description
Usage
Here we are joining the contents of A1, B1 and C1. The result of the function is seen in cell E1.
But what about the lack of spaces? Just add them in like this:
Another alternative [using the ampersand ‘&’] for adding something in a CONCATENATE function. We can use the …C1&“gmail.com”… instead of the …C1,“gmail.com”…

Be the first to comment