replace this Å“ character with pound sign in excel

R

r1947

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

MartinW

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
 
G

Gord Dibben

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

Edit>Replace

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
 
Top