nsnyder2112
New Member
- Joined
- Jan 21, 2022
- Messages
- 3
- Office Version
- 2016
- 2010
- Platform
- Windows
I am working with a system that sets up a list by creating a description then by filename with extensions. However, there is no continuity in the filename with extension sorting:
What I get:
ThisIsFile01.jpg - File01
ThisIsFile01.cab - File01
ThisIsFile02.cab - File02
ThisIsFile02.jpg - File02
ThisIsFile03.jpg - File03
ThisIsFile03.cab - File03
You can see the extensions follow no order. Yes, the descriptions are listed second but whoever created the program sorted this way first, which is fine as it helps.
This is what I would like to be able to create:
ThisIsFile01.cab - File01
ThisIsFile01.jpg - File01
ThisIsFile02.cab - File02
ThisIsFile02.jpg - File02
ThisIsFile03.cab - File03
ThisIsFile03.jpg - File03
Is there a way to set up a formula or sort process to make this happen? I have tried some of the tips and tricks with the RIGHT and LEFT but have been unsuccessful so far. Is this a VB Script thing?
Any help would be great.
What I get:
ThisIsFile01.jpg - File01
ThisIsFile01.cab - File01
ThisIsFile02.cab - File02
ThisIsFile02.jpg - File02
ThisIsFile03.jpg - File03
ThisIsFile03.cab - File03
You can see the extensions follow no order. Yes, the descriptions are listed second but whoever created the program sorted this way first, which is fine as it helps.
This is what I would like to be able to create:
ThisIsFile01.cab - File01
ThisIsFile01.jpg - File01
ThisIsFile02.cab - File02
ThisIsFile02.jpg - File02
ThisIsFile03.cab - File03
ThisIsFile03.jpg - File03
Is there a way to set up a formula or sort process to make this happen? I have tried some of the tips and tricks with the RIGHT and LEFT but have been unsuccessful so far. Is this a VB Script thing?
Any help would be great.