Excel tips : replacing dashes with periods

PRAVEEN KUMAR (MBA (Finance) B.Com.(P))   (3443 Points)

26 November 2011  

Excel Tips : Replacing Dashes with Periods

 

If you have a need to normalize the appearance of your data, you might want to replace any dashes in a text string with periods. For instance, if you have a phone number such as "123-555-1212" you might want to change it to "123.555.1212". This is easy to do using the SUBSTITUTE function:

=SUBSTITUTE(A7,"-",".")

The result is that any dashes appearing in the string in cell A7 are replaced with periods.