Find/Replace

My excel worksheet column contains the following :
es15/
ec7886/
ed8999/
es15/
et6575/

I want,


es-15/
ec-7886/
ed-8999/
es-15/
et-6575/

Originally Posted by prkundan

My excel worksheet column contains the following :
es15/
ec7886/

I want,

es-15/
ec-7886/

Assuming your column is A and the data starts on Row 1, use this formula in an unused column's Row 1 and copy down to the end of your data, then copy/paste values over top of your existing data, then delete the formulas...

=REPLACE(A1,3,0,"-")