Microsoft Office Forums

Go Back   Microsoft Office Forums > >

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: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
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: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
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

Thread Tools
Display Modes


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 06:34 PM.


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