Jan 06, 2020 06:43 AM
Hi,
Is there a way to add the content of some cells to a final one as a text ?
Example:
A1 = My text 1
B1 = Other text
C1 = Again
D1 = "Hi guys, this is “My text 1” and some “Other text”, yes “Again”!
Jan 06, 2020 07:03 AM
Hi,
The simple solution for this is this formula:
"Hi guys, this is " & A & " and some " & B & ", yes " & C
(Keep on mind that spaces must be placed inside quotation marks)
Like so:
Jan 06, 2020 08:48 AM
I noticed I also need to use { for sentence } thanks!