Thread: Generate Folder
View Single Post
 
Old 07-21-2025, 11:52 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 11 Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Quote:
Originally Posted by Scott Huish View Post
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
Reply With Quote