Help

Add different cells to an other one as a sum-up text

1865 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Inkoming
5 - Automation Enthusiast
5 - Automation Enthusiast

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

2 Replies 2
Chen_Pro
6 - Interface Innovator
6 - Interface Innovator

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:
image

Inkoming
5 - Automation Enthusiast
5 - Automation Enthusiast

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