CODEWITHSUNDEEP
google-sheets
kreatusJohn
kreatusJohn

Reputation: 67

How to join two formulas in one delimited text cell?

I'm trying to join two formulas on one cell.

For example I have these two formulas

=sum(1+1)
=multiply(1,5)

How can I combine them in one cell delimited by | ?

Upvotes: 2

Views: 11490

Answers (2)

user6655984
user6655984

Reputation:

There is concatenate which takes multiple parameters, so only one call is needed: 

=concatenate(sum(1+1), "|", multiply(1,5))

Even shorter is the binary concatenation operator &, which is what I would use:

=sum(1+1) & "|" & multiply(1,5)

Upvotes: 4

Daniel A. White
Daniel A. White

Reputation: 190976

Use 2 CONCAT calls.

=CONCAT(SUM(1+1), CONCAT("|", MULTIPLY(1,5))

Upvotes: 1

Related Questions