View (All) option (like Word) to see all white-space characters, training spaces, new-lines, etc.
Given how single trailing spaces can disrupt smooth functioning of functions, especially like VLOOKUP, it would be wonderful to have an option to display spaces, new-lines (and indeed anything else that can contribute to "hidden" white-space) just like we have been able to see in Word as an option for, ooh, about a century (or at least since the beginning of time).
At the same time, and in the same mode, a distinctive background shading or similar of numbers-stored-as-text — another huge time waster and caltrop for the novice, and even not-so-novice users.
Andrew Lister commented
Oops... "training spaces" in the title was meant to be "trailing spaces" but this site doesn't seem to offer me the opportunity to edit my post. Apologies for any misunderstandings.