gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 657
- Office Version
- 2019
- Platform
- Windows
Hello,
In Column A, from A2 down(number of cells down will differ), if the first character in a cell is NOT a number, then delete cell, shifting up on delete.
Thank you.
In Column A, from A2 down(number of cells down will differ), if the first character in a cell is NOT a number, then delete cell, shifting up on delete.
Thank you.
Replace Files.xlsm | |||
---|---|---|---|
A | |||
1 | Old File Name | ||
2 | 01. Intro.mp3 | ||
3 | Under And Over It.mp3 | ||
4 | 03. Burn It Down.mp3 | ||
5 | American Capitalist.mp3 | ||
6 | 05. Hard To See.mp3 | ||
7 | 06. Coming Down.mp3 | ||
8 | Bad Company.mp3 | ||
9 | 08. White Knuckles.mp3 | ||
10 | 09. Drum Solo.mp3 | ||
11 | Far From Home.mp3 | ||
12 | 11. Never Enough.mp3 | ||
13 | War Is The Answer.mp3 | ||
14 | 13. Remember Everything.mp3 | ||
15 | 14. No One Gets Left Behind.mp3 | ||
16 | The Bleeding.mp3 | ||
17 | |||
Test |