Map2 | ||||||
---|---|---|---|---|---|---|
B | C | D | E | |||
2 | red | blue | yellow | |||
3 | roses | red roses | blue roses | yellow roses | ||
4 | violets | red violets | blue violets | yellow violets | ||
5 | daisies | red daisies | blue daisies | yellow daisies | ||
Blad4 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C3:E5 | C3 | =TEXTJOIN(" ",1,C$2,$B3) |
Why?"I would like to get the same result with TEXTJOIN (as an array formula in one cell) as I get with CONCATENATE."
Yes, I was really thinking the same thing, but "CONCATENATE may not be available in future versions of Excel."Why?
If CONCATENATE works for you, use it.
22 02 10.xlsm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | red | blue | yellow | |||
2 | roses | red roses | blue roses | yellow roses | ||
3 | violets | red violets | blue violets | yellow violets | ||
4 | daisies | red daisies | blue daisies | yellow daisies | ||
Sheet2 (3) |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2:D4 | B2 | =B1:D1&" "&A2:A4 |
Press CTRL+SHIFT+ENTER to enter array formulas. |
Thanks for doing that.I entered my version of OS and Excel in my account details.
Good point. That method can be used very generally. It is probably what I was thinking of when I was remembering the existence of another way.you don't need CSE entry for the formula that I suggested