Wrote down the wrong name multiple times, any formulas?

[Conor D]

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?

[shg]

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

[Conor D]

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

I would really appreciate an example

[shg]

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

[Conor D]

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!