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.

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

enter image description here


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.