hi raparigo74,

UDF is user defined function.. you can make functions like the built-in excel worksheet functions.

http://www.techbookreport.com/tutorials/excel_vba1.html

so place the code in a module you can then use the "Match_Replace" UDF

eg 
a1 = word1 (123) word2 (456)
 B1= Match_Replace(A1)
the result in B1 will be "word1 word2 "

It is recommended to use "Function"s instead of "Sub"s in both worksheets and VBA