I am wanting to enter data on a sheet and then rename the sheet as the cell contents of a particular cell on the sheet. by programmatically pasting the cell contents as the sheetname. Trouble is the contents of the sheet are set by users and they have used chracters such as / or \ within the cell. Is there a simple way of removing such characters?

TIA