Hi all ;

i want to insert a macro into my excel sheet to replace each cell in a colum A :

from format :

ABC/R1/S2-7 -11

to This one ??

ABC R1.S2.LT5 .11



p.s. 7 - 2 = LT5


cAN ANY BODY HELP !!!