code to find α (alpha) and ß (beta) symbol

Hi

I am in searching of how to find the symbols like α (alpha) and ß (beta)and replace with some string like alpha , beta in sheet1.

and i tried using the find and replace with

Please Login or Register  to view this content.

even i tried using the =chr(225) but failed to identify

please kindly help me to identify


thanks in advance

Hi Andy,

Sorry to disturb you again i think the excel is not recognize the beta symbol which is present in my cell, so the above code is not working for me

my cell value is "Galactosylcer β-galactosidase, Fibro" and i also want to know how to replace all the non printable characters in the excel.

Thanks in advance

Thank you so much its working fine