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 ...
Use double quotes in Excel formulas
When you add double quotes in a formula in Excel, Excel will recognize the characters enclosed in the quotes as a part of the actual text. The upper link explains how to use double quotes in Excel formula.
If the formulas need to be translated into English or Swedish, here is a link with a translation option.
Svenska
Otherwise, if I may recommend, include the formula to illustrate the problem more clearly.
At the same time, it would be an advantage (especially for you) if the Excel version, operating system, and storage medium were always specified in the problem statement.
Hope I was able to help you with this info.
Εν οίδα οτι ουδέν οίδα (Σωκράτης)