Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How do I insert formula in between sentences? For example, in A1 i want to write:

Welcome =C1

So =C1 will replaced with anything in C1 cell.

If in A1 I write Welcome, then in B2 I write =C1 then I will get Welcome =C1, but they are in separate cells and have a space between them.

share|improve this question
up vote 11 down vote accepted

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

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

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

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)
share|improve this answer
Thanks, could you please let me know how i can also insert more, i mean, welcome C1 D1 to E1 – khalid May 16 '11 at 12:21
@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 May 16 '11 at 12:29

I am not sure I understand your question correctly but if I do, you simply enter the following formula in A1:

="Welcome " & C1

That will give you "Welcome Adam" in A1 if C1 contains "Adam".

share|improve this answer
Thanks all ........ – khalid May 17 '11 at 8:40

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.