Whenever you want to replace some text in an Excel text string, you can use the SUBSTITUTE function to do that. All you need to do to apply SUBSTITUTE is specify the cell which contains the text string you want to modify. Then you have to provide the portion of text to be replaced, and the new text to be added.
Some other related topics you might be interested to explore are LEFT, RIGHT, CONCATENATE, and MID.
This is an open-access Excel template in XLSX format that will be useful for anyone who wants to work as a Financial Analyst, Business Analyst, Consultant, Corporate Executive, or everyone preparing a corporate presentation.
You can now download the Excel template for free.