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

D

dhughes

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

Peo Sjoblom

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
 
D

Dave Peterson

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.
 
P

Paddy

dhughes said:
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!
Click to expand...

%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
 
C

Chip Pearson

%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)
 
Top