This is probably piss easy but I barely know how to use the fucking thing: is there a way to reformat cells in which the content is set out as "a/b/c" to "ab-c"?

Can't really be arsed doing 400 of the fuckers by hand.