Concatenating Text

Question

I need to concatenate text from various cells to a single cell in a row. This can go to an infinite number of rows.

How to use the CONCATENATE function in Google Sheets for doing this?

I also need to know how to use "if else if" in Google Sheets. For example:

IF(A2="This")
JOIN(" ", A2,B2)
ELSE IF(A2="I")
JOIN(" ",A2,C2)
ELSE IF(A2="value")
JOIN(" ",A2,D2)

Is this possible in Google Sheets?

please check this link [link](https://www.thoughtco.com/concatenate-text-data-in-google-spreadsheets-3123801) — Maddy, May 25 '17 at 05:27
@MaddyNikam I have edited my question according to my actual requirement. — njnjnj, May 25 '17 at 06:46

score 0 · Answer 1 · answered May 25 '17 at 05:47

0

Simply use jon function:

=join(" ", a2:e2)

You may also like this arrayFormula solution:

answered May 25 '17 at 05:47

Max Makhrov

I also need to know if I can give a condition like this: IF(CONDITION) ELSE IF(CONDITION) ELSE – njnjnj May 25 '17 at 06:27
Is it possible to use if else if? – njnjnj May 25 '17 at 06:28
I guess so, why are you asking this in a comment, not in Q? You may edit the Q and show what final result you want. – Max Makhrov May 25 '17 at 06:29

score 0 · Answer 2 · answered May 25 '17 at 13:19

0

to merge text:

=CONCATENATE(A1;" ";B1;" ";C1;" ";D1;" ";E1)

And yes you can use CONCATENATE in IF formula.

answered May 25 '17 at 13:19

a_songaila

score 0 · Answer 3 · answered May 26 '17 at 06:20

Try something like this

if(A2="This",JOIN(" ", A2,B2),IF(A2="I",JOIN(" ",A2,C2),IF(A2="value"),JOIN(" ",A2,D2),"Else Value")))

Syntax IF(logical_expression, value_if_true, value_if_false)

you can refer these links

3 Answers3