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.

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|||||
  • 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
  • 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 '11 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|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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