Find & Replace all special characters with regular

Hi all,

I've been searching for a code to find & replace all special characters in a range of data with regular alphabet letters.

For example, find all Ö and replace with O, find all ñ and replace with n, and so on and so on.

The list isn't confined to the two above, I need to make sure I find all special characters and replace with all regular characters.

So far the lists I've found are: "ŠŽšžŸÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðñòóôõöùúûüýÿ" and need to replace with "SZszYAAAAAACEEEEIIIIDNOOOOOUUUUYaaaaaaceeeeiiiidnooooouuuuyy"

I've found the following function code:

Please Login or Register  to view this content.

but 1) i'm not sure how to convert this to a procedure that runs at the click of a button and run through every cell in a range automatically (E:E should do it) to clean and replace with regular characters?

and 2) being a novice code manipulator if anyone is bored please can you explain the difference between a function & a procedure, and how to run/call the former please?

Alternatively, I came across this as well but it crashes before even running and with my limited understanding I'm at a loss why?!

Please Login or Register  to view this content.

Thanks in advance,
Mike

An idea.
1) Place :
ŠŽšžŸÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðñòóôõöùúûüýÿ in A1 or cell available
SZszYAAAAAACEEEEIIIIDNOOOOOUUUUYaaaaaaceeeeiiiidnooooouuuuyy in A2 or any cell available

Please Login or Register  to view this content.

Duplicate post.