asked on
Updating a formula that removes a specific text string from a concatenation in Excel
The current formula in Column E, shown below, concatenates Columns A, B, C and D to create a unique Product Number:
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.
Thanks in advance for assistance with this...
Andrea
Product_Numbering.xlsx
=A2&IF(B2<>"","-"&B2,"")&IF(C2&D2<>"","-"&C2&D2,"")
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.
Thanks in advance for assistance with this...
Andrea
Product_Numbering.xlsx
Microsoft AccessMicrosoft ExcelMicrosoft Office
Last Comment
Andreamary
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Cheers,
Andrea