Forum Discussion
Joining texts
Hi, Hopefully just a quick question. Been looking at the discussions on here to expand my knowledge. I came across the question of joining texts the day and I was just wondering what the advantage ...
Poogermum Just for reference, the function in English Excel is called TextJoin(), not jointext.
Concatenate() offers no advantages over using the ampersand symbol "&". It only exists to provide compatibility with other spreadsheet software. I think it goes back to the days of Lotus 1-2-3. In order to open spreadsheets that were created with Lotus 1-2-3 and were using the Concatenate() function, Excel had to have that function too, so the spreadsheet would not break.
Today, there is no reason whatsoever to use Concatenate(). Using the & sign is always shorter.
- thanks great reply!
