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!
 

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

Similar Threads

Trailing Spaces in Merged Cells 1
Macro to remove trailing spaces in cells 3
detect trailing spaces in an excel document 4
Removing leading and trailing space... 2
Highlighting leading or trailing spaces 2
How do you remove trailing spaces withour Trim function? 8
IMPORTING PC-DOS PLAIN TEXT FILES WITH LEADING SPACES 4
Deleting Leading/Trailing Spaces 2

Top