I have a cell that will be used for a filename when a user exits Excel.

I have a button that the user clicks that executes other macros after they are done entering data.

I need a macro that will search the contents of the "filename cell" and find special characters and then replace them with something else.

!!!!!!PLEASE HELP!!!!!! I don't know much about programming (probably obvious).
THANKS!!!