Using Wildcards in Substitute function

[KenCriss]

I have tried to use the Substitute function to replace part of a file. I need to do this in VBA with a UDF or something.

I want to search for this string (the characters between < employeeid >< /employeeid > could vary - that is the wildcard part)
< employeeid >A7554A01-411E-196E-E040-A8C0C2DC5F7D< /employeeid >

and replace with
< employeeid >< /employeeid >


Any thoughts on this?

 

[shg]

You can do it from the UI (or VBA if you prefer):

Find < EmployeeID >*< /EmployeeID > (sans spaces) and replace with < EmployeeID >< /EmployeeID > (sans spaces)