Only occurs in Excel 2016
Works in all other versions of Excel that I have tested (2010 and O365)
Trying to set the contents of a cell to equal :
=TEXTJOIN(" ",TRUE,"Some Text : ",CG1)
CG1 is a cell that does contain text (formatted as Geeral but have tried formatting as text also)
Have googled the issue for 2016 but nothing pops up as "OH That's It"
Any Ideas?
Works in all other versions of Excel that I have tested (2010 and O365)
Trying to set the contents of a cell to equal :
=TEXTJOIN(" ",TRUE,"Some Text : ",CG1)
CG1 is a cell that does contain text (formatted as Geeral but have tried formatting as text also)
Have googled the issue for 2016 but nothing pops up as "OH That's It"
Any Ideas?