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

Question

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".

Answer 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:

---

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

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