Select cell range from Data tab and click Sort & Filter > Advanced. Choose Filter the list in place under Action. Enter dataset range ($B$4:$D$14) and criteria range ($F$4:$F$5)
Copy and paste works directly through File Explorer without opening Excel. Save As option available within Excel app for single file copies. EaseUS Todo Backup offers automatic bulk file copying with scheduled saves
Open Excel project via File > Open or browser right-click. Select range including blank cells using drag-and-drop
Find & Replace tool removes characters by replacing them with nothing. SUBSTITUTE function removes characters from strings. Multiple characters can be removed using nested SUBSTITUTE functions
Numbers can be converted to text for search by parts. Different formatting can cause matching issues in VLOOKUP/MATCH. Numbers can be converted for ZIP codes, SSNs, phone numbers
ALT + 0176 works with numeric keypad. Requires Num lock enabled if no numeric keypad. Can be copied and pasted after insertion