If you need to substitute some characters in a cell with other characters, use SUBSTITUTE.
The layman’s syntax for the SUBSTITUTE function is:
=SUBSTITUTE(WhatCellToSUBSTITUTE, “SUBSTITUTEThisText”, “WithThis”)
How do we use this?
1. In a blank cell type =SUBSTITUTE(
2. Click on the cell you would like to substitute characters in(this automatically fills your formula)
3. Type, (comma)
4. Enter the text in quotation marks you would like substituted
5. Type, (comma)
6. Enter the text in quotation marks you would like to replace the text with and hit enter
