The tilde isn't the only sign you need to understand to truly get your head around Excel's inner workings. For example, the at (@) sign returns a single row value instead of spilling an array, the ...

Normally what we do is just press “CTRL + F”, enter ‘*’ in the ‘find’ field and click on “Find All”. It will show all the entries in the search result and there is no confusion in that. When we search ...