Code returns '63'. Looks like hyphen. Formula or VBA to Find/Replace

[MikeL]

Hi,
I did a PDF to Excel conversion on Last Names. Some names have what appear to be hyphens which is expected. (ie Zeta-Jones).
But turns out a find and replace in Excel doesn't recognized this as a hyphen. I ran a Code function on the cell and which resulted in '63'.
How to Find/Replace with a true hyphen when I dont know what the symbol is that I am finding other than the Code resulting in 63 and it looking like a hyphen?

Thanks in advance.

 

[MARK858]

Try in the Find box press and hold the Alt key and on the NUMERIC keypad, enter 0063 and in your replace just type your standard hyphen.

It must be entered on the NUMERIC keyboard and not the numbers running along the top.

 

[JoeMo]

If Mark's approach doesn't work for you, try using a formula like this (assumes you have a character 63 in cell A2):

=SUBSTITUTE(A2,CHAR(63),CHAR(45))