Forum Discussion
Excel Formulas Not Working On Programme
Hi everyone,
I'm new to Excel and I'm having difficulty with some of the functions/formulas. For example, I want to join cell A2 with B2 and place an underscore between them. Whenever I try using this formula: =CONCATENATE(A2, "_", B2), I get an error.
However, when I use the same formula on the web version of Excel, it works without any problems, just like other formulas I have tested. Is there anything I can do about it, or is using the web version of Excel my only option?
Thank you in advance.
6 Replies
Perhaps on your computer you shall use semicolons
=CONCATENATE(A2; "_"; B2)It depends on regional settings
Do you use comma as decimal separator in the desktop version? If so, use semicolon to separate the arguments of a function:
=CONCATENATE(A2; "_"; B2)
HansVogelaar
It does solve the problem, but only for this specific formula. Nearly every second formula that I use on the Excel desktop version ends up with an error message, so I am forced to use the web app version of Excel. Here is the next example:After using this simple formula, I get a #VALUE! error on the desktop version of Excel, but there is no problem with it on the web app. Is there any option to import/export formula settings from the web app?
Since you use comma as decimal separator, Q2 should be 742,50 instead of 742.50
(You can see that there is a problem: the value in Q2 is left-aligned. By default, 'real' number values are right-aligned)
