Skip to main content

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”!

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:


I noticed I also need to use { for sentence } thanks!

Reply


Terms & Conditions