I have UK organisation names where "Limited" "Ltd" and "Ltd." are all used interchangeably - can anyone think of a way to:

a) globally replace each instance of Limited/Ltd. with Ltd
b) sanitise this at point of entry with an automation

Cheers!