glad you got it worked out.

--


Gary Keramidas
Excel 2003


"John Keith" wrote in message
...
Thanks for the pointers, the problem has been solved!

The simple code line below replaces all occurences of the characters I
wanted to find:

Cells.Replace What:="?¢", Replacement:=Chr(10) & "-"

The characters are entered inside the quotes by using the key
sequences noted below:


keystroke to enter:

ALT + 0226
ALT + 0128 ?
ALT + 0162 ¢


John Keith