Figart Consulting

The CONCATENATE formula allows one to combine text from multiple cells into a single cell.

To add a blank character between words, type a space between quotation marks. This adds a blank character between the separated texts.   Whatever is between the quotes, be it a space, text or characters, it will show up in the concatenation.

So, if you were trying to create an email address at Hogwarts, the formula would be:

=CONCATENATE(A3,”.”,B3,”@hogwarts.edu”)