Suppose you need to change the appearance of the data in your worksheet. For instance, you may want to replace dashes in a text string with periods. For example, if you have a phone number formatted as 235-456-7890 you may want to change it to 235.456.7890.
This is very easy to do using the SUBSTITUTE function:
The end result is that your dashes appearing in the string in cell A3 are replaced with periods.
Told you it was easy!
Thank you to Allen Wyatt.