Looking for a way to potentially combine my formulas and haven’t had any success. I look at large, variable sheets where I only want to review the Active Description, but the data that I’m given lists the Active Description with all of the previous iterations (Inactive Description). Unfortunately, it lists the Active Description in multiple formats.

Currently I am doing the following to get a column that only has the Active Descriptions:

To only show text in asterisks:

=MID(A2,FIND("*",B2)+1,FIND("*",B2,FIND("*",B2)+1)-FIND("*",B2)-1)

To only show the Active Description when the description has the active next to a (type):

Text to columns with line break as a delimiter, then combining the results with the Active Description into one source column (issue is that it the number of line breaks can be highly variable). To only show the text that isn’t in parentheses:

=TRIM( TEXTBEFORE(B1,"("))

And finally for the descriptions that only have active in the column, I’m copying them over as is.

Is there one if statement that I can write to do it all at once?