You probably don't need an answer to this anymore, but your formula definitely can be shortened to this:
=IF(D6="","",CONCATENATE("F08.",TEXT(G6,"000")," - ",D6,", ",E6))
Kinda curious why you have buttons for creating the folders on each line as opposed to just running through them all.
|