"TiffanyD." wrote in message
...
Take a word out of all caps,

Excel have some powerfulll text functions, however for me to help you with a
formula, you have to give some examples of the data you have and the end
result. Ie

DANN - Dann

DANn - dann

or whatever you want it to do.

Correct some spelling errors,

Use Excels spellcheck - press F7.

find duplacates

Unless you are using the beta (2007 beta 2) Excel dosen't to my knowlegde
have a function to do this. However you can "cheat". What you do is to
create a new function which counts the number of occurences of a given cel
in the entire row this cell is in. If the count is over 1, then you have
dublicates. Next, you can sort by this new row with the number of entries,
and simply delete the dublicated rows (remember not to delete all rows that
have dublicates, since you will be deleting the dublicates and the original
this way).

etc.

More examples?

/Dann