Skip to main content

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

  • January 6, 2020
  • 2 replies
  • 46 views
I

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

    This topic has been closed for replies.

    2 replies

    C
    Forum|alt.badge.img+9
    • Chen_Pro
    • Known Participant
    • January 6, 2020

    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
      • Inkoming
      • Author
      • Participating Frequently
      • January 6, 2020

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

      Terms & ConditionsAccessibility statement