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