Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default 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!



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7,247
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I remove leading spaces and leave the remianing spaces w Debi Excel Worksheet Functions 6 February 28th 07 03:29 PM
Embedding spaces in an Excel file ... GBF Excel Discussion (Misc queries) 2 January 19th 07 08:34 PM
Need Help Importing Text File Using Two or More Spaces as the Delimiter [email protected] Excel Discussion (Misc queries) 11 June 13th 06 02:08 AM
Unable to open excel file and when view the file size show as 1 KB Kamal Siva Excel Discussion (Misc queries) 1 March 7th 06 03:23 AM
Last Column(=spaces) is Dropped When Importing from .Txt file Ttown Excel Discussion (Misc queries) 3 June 24th 05 06:25 PM


All times are GMT +1. The time now is 06:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"