[CoxProg]

I am trying to test the contents of cells in a table. However, the special character found in each table cell throws me off. I have some options of getting around it (described below), but are there any other suggestions on how to work around this?

Here is my simplified code:

Dim TextToTest As String

TextToTest = ActiveDocument.Tables(1).Cell(Row:=1, Column:=1).Range.Text

If TextToTest = "Sought Value" Then
MsgBox "True"
Else
MsgBox "False"
End If

My result is always "False." When I look at the extracted value of TextToTest on a cell that contains "Sought Value", I get:

Sought Value
(the next line contains a bullet looking thing that this window will not let me paste into it)

That pesky character! I have rigged some ways around it by calculating the length of the TextToTest (x) and then extracting x-2 characters from the left.

But I am looking for an option that references that special character directly. Different threads suggest the special character is "^10" or "^008" but my tests for those characters didn't seem to work.

Thanks in advance!