CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Isaac
Isaac

Reputation: 87

Cell displays "formula phrase error" is there a way to get the content of the cell?

Some of my data contain "=" at the beginning. I was able to collect and organize them to one sheet using ImportRange and Query, but then when I pasted the query output as value to another worksheet, they are not recognized as valid cell values anymore because of the equal sign.

I tried to get the cell contents using direct reference and concatenate, but all functions returned "formula phrase error".

https://i.imgur.com/lR8Iedr.png

Upvotes: 1

Views: 32

Answers (1)

player0
player0

Reputation: 1

scientific notations are not supported in such format you attempt to, hence those errors. here is a quick fix - press CTRL + H and do:

0

you need to insert something between =4.6 and E3 like:

  • &
  • +
  • -
  • /
  • *
  • &" "&
  • etc.

Upvotes: 1

Related Questions