Thread: Wrote down the wrong name multiple times, any formulas?

Doing data entry;
I have around 700 lines with random names, blah blah, basically spelt one name wrong a a fair amount of times (Read the writing wrong) is there any formulas you guys could suggest? Would be greatly appreciated.

Eg The name : Viccy
What i spelt: Vicky

Thats just an example, not the actual name for privacy issues of course. Perhaps an IF statement could fix it?

Originally Posted by shg

How about just using Find and Replace to change one to the other?

I would really appreciate an example

Originally Posted by shg

Press Ctrl+H. In the Find box, enter the misspelled name. In the Replace box, enter the corrected spelling. Press Replace All.

Fantastic, thankyou very much!
Very much appreciated!