Les,

With that string in cell A2, try the formula

=SUBSTITUTE(A2,CHAR(185),"@")

HTH,
Bernie
MS Excel MVP


"Les Stout" wrote in message ...
Hi, i download from a main frame and get the e-mail address below but it
has a funny character that excel sees as a "?" but when i code it, it is
not found ?

MARIUS.EKSTEEN¹BMW.CO.ZA

Could anybody help please !!!



Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***