How to Filter by Special Characters (?, &, $, etc.) in Google Sheets
Devin Schumacher is an entrepreneur, internet personality, author, music producer, philanthropist & founder of SERP.
Search for a command to run...
Devin Schumacher is an entrepreneur, internet personality, author, music producer, philanthropist & founder of SERP.
No comments yet. Be the first to comment.
Lost access to your Loom recordings when your subscription ended? You're not alone. Many creators discover they've accumulated dozens of valuable videos only to realize there's no simple "download" bu
How to Download Onlyfans Profile's Videos & Images for FREE (yt-dlp tutorial) 💡 Want the easy way? Get the OnlyFans Downloader extension and save OnlyFans media without commands or DevTools. Follow

How to Download Circle.so Videos for Free (HLS m3u8 Streams) - using yt-dlp Circle.so hosts course videos using HLS streaming, where video data is split into .ts segments and controlled by a .m3u8 pla

How to Download Coursera Videos for FREE (yt-dlp tutorial) 💡 Want the easy way? Get the Coursera Downloader extension and download Coursera videos without commands or DevTools. Follow along with th

How to Download Skool Videos with yt-dlp 💡 Want the easy way? Get the Skool Video Downloader extension and download Skool videos without commands or DevTools. Skool delivers videos over HLS (.m3u8

Google sheets doesn't work if your'e trying to filter by special characters.
For example, if you wnt to find all URLs in a column with a ? in them, you would naturally try this:

However it doesnt work. You can see it found "4" but there are WAY more than 4 rows with a ? in them.
Then, you might logically try this (which is already frustrating to have to think about):

but that still doesnt work (just shows everything)

What you have to do is use an "escape character" + this "filter by condition" area.
The escape character in almost everything in computer world is \, but of course Google chose not to use that (classic)...
The escape character for Google sheets is a tilde ~. (You put it before the character you are trying to escape)
So this example would be:

and tada!

1000ish rows!
TLDR: Use FILTER BY CONDITION > TEXT CONTAINS and use a tilde escape character when searching for special characters.