CODEWITHSUNDEEP
google-sheets
Denis
Denis

Reputation: 189

Function to remove all characters and special symbols in cell of Google Sheets

I have a lot of data in Google Sheets. I need some fuction to extract numbers only from:

Some_Text-is_Here_12345678_FH-1
87654321-Some-Text_is_Here-FH-2 
FH-3-00054321_Some_Text-is_Here

to new cells:

12345678
87654321
00054321

Is it possible?

Upvotes: 0

Views: 268

Answers (1)

pnuts
pnuts

Reputation: 59485

Please try:

=REGEXEXTRACT(A1,"(\d{8})")

For German locale change , to ;.

Upvotes: 1

Related Questions