Create a table or use an existing table ... There are two other methods to use the Replace function. Method one is to go to fx at the top of the worksheet on the left. An Insert Function dialog ...

Create a file system object variable and open ... Change the file's name using the Replace function. The following changes "myfile.doc" to "myfile_doc":file.Name = Replace((file.Name, ...