Mark Juniper

Power Platform | MS365 | Azure

Substitute String in Excel

Published June 1, 2015

Quick one today, use SUBSTITUTE to replace text in a string in Excel.

For example, to replace spaces with periods:

=SUBSTITUTE(B2," “,”.")