I would like Column G to concatenate different columns, including a specific string within one column, based on various criteria outlined below:
If D = "CAD" or "TREP", AND H = "VOL 1, then Column G to concatenate as follows:
G = B + D + C [first word after closing bracket OR first second word in string if no closing bracket] + F
Otherwise, Column G to concatenate as follows:
G = B + D + E + F
Format of output in Column G:
Dashes, but no spaces, between each value (as shown in attached spreadsheet example).