If I want 10 spaces between characters a and b I press the space bar 10 times, but when I hit Enter the cell defaults to only displaying 2 spaces. When I click back to edit that cell the display shows the 10 spaces, but only when I am in the edit mode for that cell.  How can I get the spacing to stay at 10?
How to add multiple spaces between characters in Google Spreadsheets?
google spreadsheets