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..

Hi,

You can use the unicode characters in Find/Replace.

Find what: alt+0156 (=o)
Replace with: alt+0163 (=£)

To use unicode hold down the Alt key and press the numbers on the number
pad then release the Alt key. You can't use the numbers at the top of
your keypad.

HTH
Martin

Π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..

Thank You Martin this works great many thanks again.....

"MartinW" wrote:

Hi,

You can use the unicode characters in Find/Replace.

Find what: alt+0156 (=o)
Replace with: alt+0163 (=£)

To use unicode hold down the Alt key and press the numbers on the number
pad then release the Alt key. You can't use the numbers at the top of
your keypad.

HTH
Martin

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..