A macro is the only way I can think of to do this. If you're interested in this
solution, post the query to the .programming group. Someone is sure to help you
out.

--
Regards,
Fred


"Tallguy63" wrote in
message ...

I deal with worksheets that have numerous foreign letters
(¡ Ñ Ú ª È Ò À Ì) and special characters. Is there a way
to find and replace them without using replace option one letter at a
time?


--
Tallguy63
------------------------------------------------------------------------
Tallguy63's Profile:
http://www.excelforum.com/member.php...o&userid=32413
View this thread: http://www.excelforum.com/showthread...hreadid=521925