Insert Column Head and Custom list macro

karkey · #1 10-21-2022, 10:00 PM

Kindly Help on this.

I have attached sample files.

p45cal · #2 10-23-2022, 07:43 AM

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)

karkey · #3 10-23-2022, 08:29 AM

How can we add some more extensions if comes.

like (e.g., .eps, .tiff, .jpg, .png)

p45cal · #4 10-23-2022, 11:53 AM

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)

karkey · #5 10-23-2022, 09:10 PM

Thanks a lot

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Want to Insert Column and add text into entire column.	Steve Kunkel	Word VBA	2	04-14-2021 07:22 PM
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
Macro to insert multiple pictures with adjustable column size	nando88	Word VBA	6	05-09-2016 11:56 PM
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