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 ...

Microsoft Excel, part of the Office software suite, allows you to create business-oriented worksheets composed of columns, rows and cells. Within these containers, characters – including special ...