ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sorting file names (https://www.excelbanter.com/excel-discussion-misc-queries/57859-sorting-file-names.html)

Gordon

Sorting file names
 
Up to now file namwes have been in alphabetical order. Now they are mixed.
How do I sort the file names into alphabetical order?

Max

Sorting file names
 
"Gordon" wrote
Up to now file names have been in alphabetical order.
Now they are mixed.
How do I sort the file names into alphabetical order?


If you mean worksheet names, try Chip Pearson's:
http://www.cpearson.com/excel/sortws.htm
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--



Gord Dibben

Sorting file names
 
If you mean filenames in a folder, perhaps you sorted them by "date" or
another means.

Try sorting by "name"


Gord Dibben Excel MVP

On Wed, 30 Nov 2005 09:02:56 +0800, "Max" wrote:

"Gordon" wrote
Up to now file names have been in alphabetical order.
Now they are mixed.
How do I sort the file names into alphabetical order?


If you mean worksheet names, try Chip Pearson's:
http://www.cpearson.com/excel/sortws.htm
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895



Gordon

Sorting file names
 
Thanks Gord (and also Max) - Yes I do mean file names in a folder. Perhaps I
am slow but can't see a sort tab/icon
Gordon

"Gord Dibben" wrote:

If you mean filenames in a folder, perhaps you sorted them by "date" or
another means.

Try sorting by "name"


Gord Dibben Excel MVP

On Wed, 30 Nov 2005 09:02:56 +0800, "Max" wrote:

"Gordon" wrote
Up to now file names have been in alphabetical order.
Now they are mixed.
How do I sort the file names into alphabetical order?


If you mean worksheet names, try Chip Pearson's:
http://www.cpearson.com/excel/sortws.htm
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895




Max

Sorting file names
 
In Windows Explorer,
Click on the folder
Click View Arrange Icons by
and you should see the droplist options to arrange by:
Name, Size, Type, Modified
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Gordon" wrote in message
...
Thanks Gord (and also Max) - Yes I do mean file names in a folder. Perhaps

I
am slow but can't see a sort tab/icon
Gordon





All times are GMT +1. The time now is 05:15 AM.

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