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 English (American) since I'm using Excel for my American university. Thus, I think there is something more that need to be adjusted in the settings, I just don't know what or how. Please help!
1 Reply
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.
