Formula - insert space after each instance of a specific character
Posted on 2013-12-17
I need to create a formula that looks at a given cell, finds all instances of a specific character, and does a substitute or replaement.
I need to have a formula that inserts a space after each comma....one that either replaces the "," with ", " or that just finds the comma and inserts a space.
cell might show the following - First National Bank,Anytown,US,12345
Needs to show as First National Bank, Anytown, US, 12345