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