How keep Leading/Trailing spaces when save in Excel?


J

jorgejulio

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!
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top