Find and return special Chars

Hi,

I'm looking for a formula that can find and return only the special chars in a string.

Example:

String: µGUA BUFFET E LOCA€ċES LTDA
Return: µ € ċ

In that particular case you could use this:

=SUBSTITUTE(SUBSTITUTE(A1,"GUA BUFFET E LOCA",""),"ES LTDA","")

but I suspect you are looking for something more general. You could have a formula with 26 nested SUBSTITUTE functions, each eliminating a single letter, but you could do it more efficiently with a user-defined function (although that would involve a bit of VBA).

Hope this helps.

Pete

Everything except A-Z a-z 0-9 and space