Quick Notes Regarding Google Sheets

• Count Duplicates in Google Sheets
• Remove Specified Text from a Cell

Count Duplicates in Google Sheets

• COUNTIF: Returns a conditional count across a range.
• COUNTIFS: Returns the count of a range depending on multiple criteria.

Remove Specified Text from a Cell

Use SUBSTITUTE function!

• Replaces existing text with new text in a string.

Ex/ SUBSTITUTE("search for it","search for","Google")

SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])

Reference: Remove whitespaces and other characters or text strings in Google Sheets from multiple cells at once - Ablebits.com