You can use the
=CONCATENATE("Welcome "; C1)
It will concatenate the string
"Welcome " with the string written in cell
See the result below:
You can also try Adam's suggestion of inserting the following in
="Welcome " & C1
The result will be the same:
If you want to insert more names just insert the cell reference where the name is written (
E1, etc) in your function separated with the ´&´ character.
See below and example:
Note: I inserted a blank space (
" ") to separate the names, however your can insert
"," or anything else.
The same thing can be done using the
=CONCATENATE("Welcome "; C1; " "; D1; " "; E1)