Why?

Excel Spreadsheets are used for multiple purposes – from financial models to creating various lists. There are people who uses Excel for creating dumps for data, which includes dumping multiple lines of data in a single cell.

Though Excel comes really handy in such activities, but there is one drawback that makes using Excel cumbersome in such tasks. That is – absence of Bullets & Numbering as available in MS Word or MS PowerPoint. Some people do make-shift arrangements of using a hyphen (–) sign to mark each line entered in a same cell as a new line.

You are making a massive Excel report or some complex valuation model or anything that deals with making Excel work for you, and then after putting in hours of efforts, what you see on your laptop’s screen is a number of ‘#NAME?‘ or ‘#REF!‘ or something like ‘#DIV/0‘. Then you kind of start pulling your hair start thinking ‘now what the hell these weird symbols mean?’. i’ll say don’t fret, it’s quite Excel to Err!!