How to change number display format in Google Sheets?

Z

Zakonoposlushniy2021-10-19 12:02:25

Google Sheets

Zakonoposlushniy, 2021-10-19 12:02:25

How to change the number display format in a cell?

There is a cell with a view number +7 (999) 999-99-99.

It is necessary to duplicate these numbers in the next cell, but without spaces, brackets and dashes. That is, like this +79999999999:

How can I do that?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

G

Grigory Boev, 2021-10-19
@ProgrammerForever

=REGEXREPLACE(A1;"[^1-9+]+";"")