When I copy a formula from a text file into a Google Sheet, it shows up as plain text in the sheet rather than being used as a formula.
For example if I copy "=2+3" (not including the quotes) from a text file, and I paste that into a Google Sheet then it pastes as "'=2+3" with a leading apostrophe so that the cell shows the text "=2+3" (not including the quotes).
I have found that "Paste special > Formula only" and "Paste special > Values only" only work when copying from one spreadsheet cell to another. Since I'm copying from a plain text file, those operations do nothing.
I am attempting to paste in thousands of formulas, so typing them in by hand is not feasible. Any help is much appreciated!