Ok I figured out what to do but I need help to pull it off.

In a hidden cell, what would be the formula to search for "/" and if it's present then delete it? That should work.