Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 07-21-2025, 05:25 PM
Scott Huish Scott Huish is offline Generate Folder Windows 11 Generate Folder Office 2021
Novice
 
Join Date: Jul 2025
Posts: 9
Scott Huish is on a distinguished road
Default

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.
Reply With Quote
 

Thread Tools
Display Modes


Other Forums: Access Forums

All times are GMT -7. The time now is 02:02 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft