Insert Column Head and Custom list macro

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Insert Column Head and Custom list macro

FAQ

Thread Tools

Display Modes

10-23-2022, 11:53 AM

p45cal

Windows 10 Insert Column Head and Custom list macro

Office 2019

Expert

Join Date: Apr 2014

Posts: 948

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)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

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