Timeline for Combine text from multiple cells into a single cell on other Sheet?
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 3, 2018 at 23:11 | comment | added | user0 |
@Vic =JOIN(CHAR(10); FILTER(ARRAYFORMULA(Sheet1!B1:B &" "& Sheet1!C1:C &" "& Sheet1!D1:D&CHAR(10)); Sheet1!A1:A=G3))
|
|
| Sep 3, 2018 at 22:14 | comment | added | user0 |
@Vic add one more CHAR(10)
|
|
| Sep 3, 2018 at 16:27 | comment | added | Vic | Thanks a lot, now another question how can I insert a line break or an empty line after every line? | |
| Aug 30, 2018 at 15:17 | vote | accept | Vic | ||
| Aug 30, 2018 at 14:58 | vote | accept | Vic | ||
| Aug 30, 2018 at 14:58 | |||||
| Aug 30, 2018 at 8:23 | history | edited | user0 | CC BY-SA 4.0 |
added 282 characters in body
|
| Aug 30, 2018 at 8:05 | history | edited | user0 | CC BY-SA 4.0 |
added 120 characters in body
|
| Aug 30, 2018 at 7:56 | history | answered | user0 | CC BY-SA 4.0 |