8

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.

Improve this question

2 Answers 2

Reset to default
14

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

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".

Improve this answer
0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .