Hi,

I couldn't get the simple =CONCAT(A1, A2) to work. =CONCAT(A1:A2) worked perfectly, but the former didn't. All I got is the 'problem with the formula' message.

I tried cell formatting, new sheets, nothing worked. I was barking mad.

And then I replaced commas , with semicolons ; and voila.

The official in-app user guide (Excel for Mac Help) says that =CONCAT(A1," ", A2) is correct. I'm using Excel for Mac 16.67 under 365 subs on a Ventura Mac.

My system is set to US English, I'm using US keyboard layout, my region is Czechia - which uses 1 300 000,25 format. Is this the reason? Is there a way how to force Excel to use commas? I couldn't find anything in the Excel Settings pane and I'm reluctant to change the Mac's system preferences.

The thing is that if I paste content of that uses commas, I end up with text values...

Any advice appreciated.

Thanks.