issues with calc's command "find and replace"

[Tadeu]

I need to transpose lots of data into a new sheet on CALC.
So I generate the relations using the “concatenate” command, e g:

´=IF($dados.$C$4="","",$dados.$C4)

So I copy and paste (special text numbers) to the cells where I need to put my data.
All I have now is a lot of cells with text similar to the text above.

The next step will be to use the command “find and replace” to replace '= by =.
When I perform this command the result is an Error501 and the text was altered as:

=IF($dados.$C$4=)

No matter what I do, I can not perform this task.

I hope someone had faced this same issue and can help me.

Thanks in advance.

[qubit1]

Anonymous – did you find an answer to your question? Did mariosv’s answer work for you?

[mariosv]

Maybe prior to introduce the first formula, the cell is formatted as text, this is why the formula is putting in the cell as a text not as a formula.