My Excel spreadsheet has a column with data that has tabs and spaces in it (screenshot below). However, because Excel does not show the tabs and spaces, the data lacks visual organisation. However, Excel appears to switch to a "preview mode" for the cell when I double-click on it and does show the tabs and spaces (screenshot below).
Is there a method to instruct Excel to automatically show the data with tabs and spaces (without requiring a double-click on a cell)?
View if I double-click on this same cell (tabs and spaces are displayed by Excel, like I need by default):