I have a defined table. I want to amend contents of few cells in a column. This is mainly because operator for input of data didn't use a data validation rule and there are minor mistakes in spelling of contents. For example, cells are like this: Main gate, Main_gate, Main-gate and I have to correct them in order to get proper report in pivot table. Some are much more hard to grasp like: Main gate south, Main gate north. I have to change all of them into Main gate. If there is a fast way to do it, let me know. If there isn't and I have to do it manually (and I think so) can I change without using a helper column?