ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why does my file name show %20s instead of spaces? (https://www.excelbanter.com/excel-discussion-misc-queries/144157-why-does-my-file-name-show-%2520s-instead-spaces.html)

dhughes

Why does my file name show %20s instead of spaces?
 
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!

Peo Sjoblom

Why does my file name show %20s instead of spaces?
 
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!




Dave Peterson

Why does my file name show %20s instead of spaces?
 
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

Paddy

Why does my file name show %20s instead of spaces?
 

"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



Chip Pearson

Why does my file name show %20s instead of spaces?
 
%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





All times are GMT +1. The time now is 10:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com