Hi,

I would like to know is it possible - if I paste a file name in cell :-

A1 "J000379_Existing_S-001-02" then it will show in cell B1 "Schematic" - it's pick up the unique abbreviation "S-"

or

A1 "J000379_Existing_L-001-02" then it will show in cell B1 "Site Layout" - it's pick up the unique abbreviation "L-"

and so on

General Arrangements A-
Civil C-
Site Layout Drawings L-
Schematic Diagrams S-
Wiring Diagrams W-
Multicore Cable Diagrams M-
Block Cable Diagrams B-
Documents D-
Vendor V-

Thank you