Snippets Collections

Recent | Popular

view_listList view view_moduleGrid view
content_copy

#sheets #googlesheets

How to remove (and replace) white spaces between words 
=REGEXREPLACE(A2, "\s", "_")
content_copy

#sheets

Use the COUNTIF formula to find duplicates. 
=COUNTIF (A:A, A1)>1
content_copy

#google #sheets

How do you remove all text to the left of the last '/' on Google Sheets? - Quora 
=index(split(B2,"/"),len(B2)-len(substitute(B2,"/",""))+1) 
content_copy

#gquery #sheets

Google Sheets Query IN() Function 
WHERE A MATCHES '"&TEXTJOIN("|",true,E1:E)&"'
open_in_new

#google #sheets

google sheets - How to refer to 'this' cell in a conditional formatting formula? - Web Applications Stack Exchange
https://webapps.stackexchange.com/questions/87025/how-to-refer-to-this-cell-in-a-conditional-formatting-formula

How to remove (and replace) white spaces between words
star

Fri Sep 20 2024 00:24:23 GMT+0000 (Coordinated Universal Time) https://stackoverflow.com/questions/67045764/how-can-i-remove-white-spaces-between-words

#sheets #googlesheets

Use the COUNTIF formula to find duplicates.
star

Mon Aug 12 2024 12:13:04 GMT+0000 (Coordinated Universal Time)

#sheets

How do you remove all text to the left of the last '/' on Google Sheets? - Quora
star

Sat Apr 23 2022 21:56:15 GMT+0000 (Coordinated Universal Time) https://www.quora.com/How-do-you-remove-all-text-to-the-left-of-the-last-on-Google-Sheets

#google #sheets

Google Sheets Query IN() Function
star

Thu Mar 31 2022 14:51:53 GMT+0000 (Coordinated Universal Time)

#gquery #sheets

google sheets - How to refer to 'this' cell in a conditional formatting formula? - Web Applications Stack Exchange
star

Fri Apr 02 2021 01:24:18 GMT+0000 (Coordinated Universal Time) https://webapps.stackexchange.com/questions/87025/how-to-refer-to-this-cell-in-a-conditional-formatting-formula

#google #sheets

Save snippets that work with our extensions

Available in the Chrome Web Store Get Firefox Add-on Get VS Code extension