I don't know how to write this argument in a formula ... hope you can help.
Examples of Data from column B:
B2 = (LMP) AMC-AMCC-PMG-C
B3 = (LMP) AMC-AMCC-AF
B4 = (LMP) AMC-AMCC-CPR-B
B5 = (LMP) AMC-DLA:CCAD-AMCC
B6 = (LMP) AMC-AMSAM-CC-MP-A-AB
Formula to start in M2:
If the first 14 characters in B2 equals “(LMP) AMC-AMCC” then return with the first 17 characters of B2 (example of answer: “(LMP) AMC-AMCC-PM”);
If the first 14 characters DO NOT equal “(LMP) AMC-AMCC” then return with the contents of column B (example of answer: “(LMP) AMC-AMSAM-CC-MP-A-AB”).
Examples of Data from column B:
B2 = (LMP) AMC-AMCC-PMG-C
B3 = (LMP) AMC-AMCC-AF
B4 = (LMP) AMC-AMCC-CPR-B
B5 = (LMP) AMC-DLA:CCAD-AMCC
B6 = (LMP) AMC-AMSAM-CC-MP-A-AB
Formula to start in M2:
If the first 14 characters in B2 equals “(LMP) AMC-AMCC” then return with the first 17 characters of B2 (example of answer: “(LMP) AMC-AMCC-PM”);
If the first 14 characters DO NOT equal “(LMP) AMC-AMCC” then return with the contents of column B (example of answer: “(LMP) AMC-AMSAM-CC-MP-A-AB”).