How keep Leading/Trailing spaces when save in Excel? I have values with leading and trailing spaces in Excel cells, file is .CSV(Comma-Separated values) format.

Example values within cells are:
"10A "
" 6B "
" 5A 3C"

When I save the above in Excel it removes leading and trailing spaces, is there a way to tell Excel to keep these? I have tried Cell Format = "Text" (show as user-entered) but this still removes the leading/trailing spaces!