Hi
maybe something like
range("A1").value=Replace(range("A1").value, chr(10),"")

--
Regards
Frank Kabel
Frankfurt, Germany


Rocky McKinley wrote:
I have cells with Asc(10) characters in them, however when I press
the
Delete key or Clear Contents or make the cell = "" the character
still
remains in the cell. How can I rid myself of the character using
code? I can get rid of it manually by selecting the cell, clicking
in the formula bar and back spacing.
Any ideas would be appreciated, thanks.