A practical tutorial on how to standardize and modify URL datasets in Excel, Google Sheets, or other table processors. I’ll teach you how to clean up trailing slashes, WWW subdomain, change HTTP to HTTPS, and much more useful tricks for trimming or concatenating URLs. You’ll appreciate this information during work with the complex datasets, preparing redirection tables, or experimenting.
Filter values with question mark or asterisk in Excel
Asterisk *
and question mark ?
play special roles in Excel. Both are wildcard symbols. Asterisk can replace any string. A question mark can replace any single character.