Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Whenever I save a file from Excel to a floppy disk it adds "%20" instead of
spaces. Is there anyway to keep this from happening? Thanks! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Avoid saving files on floppies, sooner or later you will get a corrupt file,
save it on the HD, then transfer it to the floppy -- Regards, Peo Sjoblom "dhughes" wrote in message ... Whenever I save a file from Excel to a floppy disk it adds "%20" instead of spaces. Is there anyway to keep this from happening? Thanks! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I agree with Peo. But I'm betting that you downloaded a file from the
internets. Lots of times, filenames get that %20 stuff instead of spaces. It's got to do with HTML and links and stuff I don't know about. dhughes wrote: Whenever I save a file from Excel to a floppy disk it adds "%20" instead of spaces. Is there anyway to keep this from happening? Thanks! -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() "dhughes" wrote: Whenever I save a file from Excel to a floppy disk it adds "%20" instead of spaces. Is there anyway to keep this from happening? Thanks! %20 is a space. 20 decimal is the ASCII code for space; % indicates that the number following defines that character in terms of ASCII code. To stop it from happening, don't use spaces. Use dash or underscore instead. Paddy |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
%20 is a space. 20 decimal is the ASCII code for space;
Close but not quite. The '20' is hex, not decimal, for a space. Decimal is 32. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting LLC www.cpearson.com (email on the web site) "Paddy" wrote in message ... "dhughes" wrote: Whenever I save a file from Excel to a floppy disk it adds "%20" instead of spaces. Is there anyway to keep this from happening? Thanks! %20 is a space. 20 decimal is the ASCII code for space; % indicates that the number following defines that character in terms of ASCII code. To stop it from happening, don't use spaces. Use dash or underscore instead. Paddy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
Embedding spaces in an Excel file ... | Excel Discussion (Misc queries) | |||
Need Help Importing Text File Using Two or More Spaces as the Delimiter | Excel Discussion (Misc queries) | |||
Unable to open excel file and when view the file size show as 1 KB | Excel Discussion (Misc queries) | |||
Last Column(=spaces) is Dropped When Importing from .Txt file | Excel Discussion (Misc queries) |