Thank You Gord Dibben this works great many thanks again.....

"Gord Dibben" wrote:

Πchanracter is ascii 0156 and found in the Character Map under many different
font types.

EditReplace

What: Alt + 0156

With: Alt + 0163

Note: you must hold the Alt key and enter the numbers using the NumPad.

Replace all.


Gord Dibben MS Excel MVP


On Fri, 6 Apr 2007 00:16:01 -0700, r1947
wrote:

When copying from Outlook Calendar to Excel worksheet this character œ
replaces the £ sign on the excel worksheet, it is not in any of the character
map options and cannot replace it on the find and replace options because i
cannot copy and paste the œ onto the find box to replace every other
character copies ok to excel..