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.

Almost 17 years later, and not really to the point, is it?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I'm not allowed to ask questions? What's wrong with it?