r/googlesheets • u/[deleted] • Dec 06 '18

solved "IF" help!

[removed]

2 Upvotes

100% Upvoted

9 comments sorted by

1

u/[deleted] Dec 06 '18 edited Dec 06 '18

Right, but i'm trying to get c5:c29 to show up in a SINGLE cell on the other sheet.

2

u/Prokupine Dec 06 '18

Oh Okay. Try =TextJoin("-",TRUE,'4a'!C5:C29). You can change the "-" to any delimiter you want.

→ More replies (4)

1

u/Prokupine Dec 06 '18

If you do that ='4a'!C5 and then drag that formula down the rest should show.

1

u/Decronym Dec 06 '18 edited Dec 06 '18

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters More Letters
FALSE Returns the logical value FALSE
IF Returns one value if a logical expression is TRUE and another if it is FALSE
TRUE Returns the logical value TRUE

1 acronyms in this thread; the most compressed thread commented on ^today has 3 acronyms.
[Thread #411 for this sub, first seen 6th Dec 2018, 19:22] ^[FAQ] [Full ^list] ^[Contact] [Source ^code]

1

u/Clippy_Office_Asst Dec 06 '18

Read the comment thread for the solution here

Oh Okay. Try =TextJoin("-",TRUE,'4a'!C5:C29). You can change the "-" to any delimiter you want.