Chr(13) is a carriage return. It is not an end of cell marker.

The end of cell marker is an awkward beast. You cannot search for it, you cannot change it, you cannot, really, do much with it at all.

Try this:

In Word, type a few characters, then a paragraph mark (hit return). then insert a table and enter some text in the first couple of cells. Hit ctrl+home to go to the beginning. Ctrl+f to bring up Find - check "Use Wildcards" and look for * (or ? if you like). Now keep hitting find next and watch as it steps through the characters - it will select each one in turn, including the paragraph mark (whether or not you have them displayed), but inside the table it will skip from the last character of one cell to the first of the next without selecting the end of cell marker - it is not a proper character.

Now try this

Select a cell
Paste this code somewhere and run it
[VBA]Sub seecell()
Dim ch
For Each ch In Selection.Characters
MsgBox Len(ch) & " " & Asc(ch) & " " & Asc(Right(ch, 1))
Next
End Sub[/VBA]
It will give you a msgbox for each character in the cell - showing 1 nn nn where 1 is the length of the character and nn is the ascii code for the character - except for the last character which is the end of cell mark, when it will show 2 13 7. The end of cell marker is a character of length 2; the first (whatever you call half a character) is chr(13) and the second is chr(7).

Just be aware of it - you can't do anything about it.