Removing Text Conditionally
There is an Excel file that teaches how to perform the Removing Text Conditionally operation.
Excel Template for Removing Text Conditionally
This workbook demonstrates removing text conditionally using VBA macros on a 28-row data layout.
Hope it is useful.