Thread: [Solved] Insert Column Head and Custom list macro
View Single Post
 
Old 10-23-2022, 07:43 AM
p45cal's Avatar
p45cal p45cal is online now Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 870
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
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