Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Insert Column Head and Custom list macro Insert Column Head and Custom list macro
Register FAQ Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 10-21-2022, 10:00 PM
karkey karkey is offline Insert Column Head and Custom list macro Windows 10 Insert Column Head and Custom list macro Office 2013
Novice
Insert Column Head and Custom list macro 		 
Join Date: Jan 2021
Posts: 19
karkey is on a distinguished road
Default Insert Column Head and Custom list macro
Kindly Help on this.




I have attached sample files.
Attached Files
File Type: xls b4920-ch01_Input.xls (25.5 KB, 7 views)
File Type: xls b4920-ch01_Output.xls (26.0 KB, 6 views)
Reply With Quote
  #2  
Old 10-23-2022, 07:43 AM
p45cal's Avatar
p45cal p45cal is offline Insert Column Head and Custom list macro Windows 10 Insert Column Head and Custom list macro Office 2019
Expert
  
Join Date: Apr 2014
Posts: 719
p45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud of
Default
Code:
=INDEX({"InFig";"SFig";"Fig"},MATCH(MID(SUBSTITUTE($B2,".eps",""),10,1),{"a";"s";"f"},0)) & VALUE(MID(SUBSTITUTE($B2,".eps",""),11,2)) & MID(SUBSTITUTE($B2,".eps",""),13,99)
Reply With Quote
  #3  
Old 10-23-2022, 08:29 AM
karkey karkey is offline Insert Column Head and Custom list macro Windows 10 Insert Column Head and Custom list macro Office 2013
Novice
Insert Column Head and Custom list macro 		 
Join Date: Jan 2021
Posts: 19
karkey is on a distinguished road
Default can we add show extensions
How can we add some more extensions if comes.

like (e.g., .eps, .tiff, .jpg, .png)
Reply With Quote
  #4  
Old 10-23-2022, 11:53 AM
p45cal's Avatar
p45cal p45cal is offline Insert Column Head and Custom list macro Windows 10 Insert Column Head and Custom list macro Office 2019
Expert
  
Join Date: Apr 2014
Posts: 719
p45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud of
Default
Code:
=INDEX({"InFig";"SFig";"Fig"},MATCH(MID(LEFT(B2,FIND(".",$B2)-1),10,1),{"a";"s";"f"},0)) & VALUE(MID(LEFT(B2,FIND(".",$B2)-1),11,2)) & MID(LEFT(B2,FIND(".",$B2)-1),13,99)
Reply With Quote
  #5  
Old 10-23-2022, 09:10 PM
karkey karkey is offline Insert Column Head and Custom list macro Windows 10 Insert Column Head and Custom list macro Office 2013
Novice
Insert Column Head and Custom list macro 		 
Join Date: Jan 2021
Posts: 19
karkey is on a distinguished road
Default Thanks
Thanks a lot
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert Column Head and Custom list macro Want to Insert Column and add text into entire column. Steve Kunkel Word VBA 2 04-14-2021 07:22 PM
Insert Column Head and Custom list macro Macro To Identify & Highlight Words In MS Word Based Upon A List In Excel File Column abhimanyu Word VBA 5 03-20-2020 01:33 PM
Insert Column Head and Custom list macro Macro to insert multiple pictures with adjustable column size nando88 Word VBA 6 05-09-2016 11:56 PM
Insert Column Head and Custom list macro Embedded Excel in Powerpoint - custom animation, display column by column andytheanimal PowerPoint 2 01-20-2015 06:30 AM
Custom column in "List" view, show on Contact Card phillyhy Outlook 0 05-16-2012 11:13 PM

Other Forums: Access Forums

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

Contact Us - Privacy Statement - Top

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