How keep Leading/Trailing spaces when save in Excel?
 

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 a
"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!


--
jorgejulio
------------------------------------------------------------------------
jorgejulio's Profile: http://www.excelforum.com/member.php...o&userid=36999
View this thread: http://www.excelforum.com/showthread...hreadid=567220