How can I change a row to be a text instead of a formular?

Question

I have a row that contains phone-numbers. After "copy/pasting" the values from excel it creates formulars and shows now "#ERROR" instead of the phone number. How can I format this row the right way to show the phone-numbers again?

Example: =+49 4942 12345678 - Shows: #ERROR! . I want to remove the "=" sign.

Answer 1

Replace equals sign (=) with single quote (').

'Ctrl + h' will bring up the Find and Replace dialog.

In the sample image below I configured the range as the entire column G. You would enter the row or column or even individual cells that are affected as the case may be.

You must select "also search within formulas" or it will ignore the affected cells.