Forum Discussion
Formula with quotation marks
I'm trying to use the LEFT (and RIGHT) formula but it doesn't work because of the quotation marks in it. I have a Swedish keyboard and a Swedish account on Office 365 but has changed the settings to ...
If you now use US English settings, you should use comma , instead of semicolon ; between the arguments of a function, e.g.
=LEFT("Sweden",3)
should return "Swe".
Apart from that: please provide more detailed information about the formula you want to create.