Editing Text Conditionally

There is an Excel file that teaches how to perform the Editing Text Conditionally operation.

Excel Spreadsheet for Editing Text Conditionally

This workbook demonstrates editing text conditionally with formulas on a 20-row data layout.

Hope it is useful.