Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
G
G
Gerich44442021-11-26 22:33:05
Google Sheets
Gerich4444, 2021-11-26 22:33:05

Why is there a syntax error in a Google Sheets formula?

In one of the tables, it turns out to extract the numbers from the cell using the function =REGEXREPLACE(C2221,"\D+", ""), but for some reason in the other table, the same formula produces a syntax error in the same situation. What's the matter?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
D
dollar, 2021-11-26
@Gerich4444

=REGEXREPLACE(TEXT(C2221),"\D+", "")

Similar questions
V
vladislavik952021-12-29 13:05:31
How to pull the contents of the cells to top? 2Reply
A
Ankitony2018-10-30 00:03:22
How to put down the time in the next cell? 1Reply
S
serw_802020-09-10 06:27:38
How to copy google spreadsheet rows that meet a condition? 1Reply
A
avocadooboom2020-09-10 09:34:30
How to make a link to data from a cell in google sheets? 1Reply
A
arr0w2020-09-12 21:33:46
How to count the number of values ​​in cells? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question