I need to update the current formula whereby if the specific text string "-AAU" is in Column B, it is not to be included in the final concatenated Product Number in Column E.
I have included a sample spreadsheet that has the current formula in Column E, and the updated, desired results I am looking for in Column F.
Cheers,
Andrea