Delete Asc(10) character from cell

[Rocky McKinley]

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.

 

[Frank Kabel]

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

 

[Rocky McKinley]

Unfortunatley that didn't work, thanks for the try though.

 

[Gord Dibben]

Rocky

How do you know the character is asc(10)?

Maybe asc(13) or some other.

Check out Chip Pearson's Cellview add-in to see what you have in the cell(s)

http://www.cpearson.com/excel/CellView.htm

Gord Dibben Excel MVP

 

[Rocky McKinley]

I used the code below to check the cell in question and the message box came
up with 10 as the only answer.

Sub CheckCellValue()
Dim a as Integer
For a = 1 To 255
If Chr(a) = Range("AE16").Text Then MsgBox a
Next a
End Sub

I'll check out Chip's page as you suggested, thanks.

 

[Rocky McKinley]

Chips Add-In comfirms as my code below did that the Decimal character is
010. It really doesn't matter what character it is as long as I can get rid
of it, that is the main problem. I'm sure someone must have ran into this
one before!

Any help is still appreciated.

 

[Rocky McKinley]

Problem solved thanks for all the help.

 

[Tom Ogilvy]

ActiveCell.Clearcontents

does exactly that - Asc(10) is not ignored.

You probably didn't apply it to the cell in question.