Hi Forum
Im trying to find a way of tidying data that is the same thing but slightly different in the way its typed i.e. the example below which has three different entries, 1 is correct, 2 has a full stop or 3 with has an S. I appreciate the obvious solution is to clean the data tool that its coming from, which I am working on but need a quick solution to use on old data.

I can't think of anything but I'm always surprised when someone comes back with a fix option, so thought I would ask. Thanks

Example
1) BLANK COMPONENT
2) BLANK COMPONENT.
3) BLANK COMPONENTS