View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
r1947 r1947 is offline
external usenet poster
 
Posts: 6
Default replace this o character with pound sign in 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