07-21-2025, 11:52 PM
|
 |
Expert
|
|
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
|
|
Quote:
Originally Posted by Scott Huish
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
|
Windows 11 
Office 2021
Hybrid Mode