How do I insert formula in between sentences?
Hire the world's top talent on demand or became one of them at Toptal: https://topt.al/25cXVn
and get $2,000 discount on your first invoice
--------------------------------------------------
Music by Eric Matyas
https://www.soundimage.org
Track title: Switch On Looping
--
Chapters
00:00 How Do I Insert Formula In Between Sentences?
00:27 Accepted Answer Score 14
01:18 Answer 2 Score 7
01:33 Thank you
--
Full question
https://superuser.com/questions/284185/h...
--
Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...
--
Tags
#microsoftexcel #worksheetfunction
#avk47
ACCEPTED ANSWER
Score 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:
You can also try Adam's suggestion of inserting the following in A1:
="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 (C1, D1, 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 function:
In cell A1 insert:
=CONCATENATE("Welcome "; C1; " "; D1; " "; E1)
ANSWER 2
Score 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".