Remove characters from a file name

[gtd526]

Hello,
How to remove characters from beginning of a file in a certain folder?
I can identify the folder from a cell. (myPath="A1")
File Name (example):
07. White Knuckles.mp3
07 White Knuckles.mp3
7 White Knuckles.mp3

Maybe removing from the first space and backwards?
Thank you.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[gtd526]

Glad we could help & thanks for the feedback.

One more question
How can I add a "\" (backslash) to the end of a folder name.
I have a folder name in E1, but need that backslash for macro to work.

Replace Files.xlsm
	D	E
1	Folder To Fetch:	C:\Users\Greg\Music\Five Finger Death Punch\Test
Sheet1

I have 3 macros for changing the file name. 1. Get file name from folder 2. Make changes of file name 3. send changed file name to folder.
I'm putting it together in 1 macro.
I will let you know how it works out.

 

[Fluff]

As that is a totally different question, you will need to start a new thread.

 

[gtd526]

Here are my results.

Replace Files.xlsm
	A	B
1	Old File Name	New File Name
2	1 Intro.mp3	#VALUE!
3	02. Under And Over It.mp3	#VALUE!
4	03. Burn It Down.mp3	#VALUE!
5	04. American Capitalist.mp3	#VALUE!
6	05. Hard To See.mp3	#VALUE!
7	06. Coming Down.mp3	#VALUE!
8	07. Bad Company.mp3	#VALUE!
9	08. White Knuckles.mp3	#VALUE!
10	09. Drum Solo.mp3	#VALUE!
11	10. Far From Home.mp3	#VALUE!
12	11. Never Enough.mp3	#VALUE!
13	12. War Is The Answer.mp3	#VALUE!
14	13. Remember Everything.mp3	#VALUE!
15	14. No One Gets Left Behind.mp3	#VALUE!
16	15. The Bleeding.mp3	#VALUE!
Sheet1

Cell Formulas
Range	Formula
B2:B16	B2	=REPLACE(A2,1,FIND(" ",A2),"")

Yes. Your formula is working. I restarted my computer and tried it again, and it works.
Why it didn't at first, I don't know. I blame the AMD processor, not Intel??

 

[Fluff]

Thanks for letting us know.