In the file above, I am getting syntax error on B4, despite the formula seems correct. Can anyone reproduce the problem? How can I solve it?
MacBook Air, OS X Yosemite (10.10.5), Numbers version: 3.6.1 (2566)
Ask Different is a question and answer site for power users of Apple hardware and software. It only takes a minute to sign up.Sign up to join this community
Some locales use semicolon as a separator for parameters in formulae, such as Turkey. You can check this by using a comma after the first parameter, then clicking a cell. If you see a semicolon being inserted alongside the comma you should use a semicolon as a delimiter.
This feels like a bug. Copy-pasting the cell shows the syntax error, but copy-pasting the contents of the cell (the formula itself) works fine, alongside me retyping the formula. You can provide feedback to Apple here:
I had better luck using "string1" & "string2".