You can use the CONCATENATE
function.
In cell A1
put:
=CONCATENATE("Welcome "; C1)
It will concatenate the string "Welcome "
with the string written in cell C1
.
See the result below:
![enter image description here](../../I/static/images/30848e3e56803eac678ebeadd9aff5a16b4ccb22692c5c2aef8e54795e495cad.jpg)
You can also try Adam's suggestion of inserting the following in A1
:
="Welcome " & C1
The result will be the same:
![enter image description here](../../I/static/images/a67d09a609e2aa105da93aefef6ac5b268099bfd2ca75b45edb552e28310351c.jpg)
If you want to insert more names just insert the cell reference where the name is written (C1
, D1
, E1
, etc) in your function separated with the ´&´ character.
See below and example:
![enter image description here](../../I/static/images/ef0c7cd362cc4feb751995e9ec70727c8ea37ebcae2b82c7b59595497e8fedd7.jpg)
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
function:
In cell A1
insert:
=CONCATENATE("Welcome "; C1; " "; D1; " "; E1)
Thanks, could you please let me know how i can also insert more, i mean, welcome C1 D1 to E1 – khalid – 2011-05-16T12:21:17.430
1@khalid, you can concatenate as many times as you like, so you can add more linkages either with
=CONCATENATE("Welcome ";C1;D1;E1)
or="Welcome " & C1 & D1 & E1
. – DMA57361 – 2011-05-16T12:29:49.577