K
K
Kit Scribe2020-05-21 12:48:29
Regular Expressions
Kit Scribe, 2020-05-21 12:48:29

How to compose regexp for Google Sheets?

Hello. I ran into a problem that I can't solve.

I have a table with cell D containing phone numbers.
The numbers go in this format:

7 900 000 00 00
8 900 000 00 00


I need to make a regular expression or a formula, which I will stretch onto a plate and change the phone numbers into a single format:
8 900 000 00 00

I tried =REGEXREPLACE, because I rummage more in regular expressions, but I could not solve the problem.

Ask for help from the community. Thanks

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
dodo512, 2020-05-21
@kitscribe

=REGEXREPLACE(D1, "^7 ", "8 ")

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question