How to remove "+" from the formula if the cell contains "#ERROR"?

A

A

Andrew2021-07-15 11:00:25

Google Sheets

Andrew, 2021-07-15 11:00:25

How to remove "+" from the formula if the cell contains "#ERROR"?

Hello
Sparsil numbers in the format +7(999) 999-99-99. But if there is a "+" in the cell, then it becomes a formula, and the "=" sign is added immediately to the beginning. And the output is "#ERROR" .

The question is, is it possible to change the formula through some kind of formula? To remove "=" and "+" from a cell

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

R

robprane, 2021-07-15
@AHgPeKa

It is possible through search in a range.

Similar questions

K

KriptoAnalytic2018-02-06 14:11:31

How to shorten this google apps script code? 1Reply

S

sashka_shishka2018-02-14 11:51:54

How to implement Google Forms data collection principle for Google Sheets? 1Reply

E

Evgenia Satonina2020-04-24 16:19:31

How to transfer an image from one sheet to another so that people who have access via the link can see them? 0Reply

A

Alina Shah2020-04-27 16:12:44

How to make a universal age calculation formula? 1Reply

D

Dofre2020-04-28 12:34:49

Why doesn't the program work as expected when changing just one typical command? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question