VBA parsing as a string help and using string.replace

[aedctalk]

In the following bit of code, how would i parse or convert adoRS(2) to a string please (? I'm a bit new to parsing/converting to strings.. :/

also (less important) but if you could also tell me.. how i'd do the following that would be a huge huge help.

adoRS(2) is a sentance/message

[COLOR=#1f497d]Do While adoRS.EOF <> True<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>[/COLOR]
[COLOR=#1f497d]        If Range("A" & x).Value <> "" Then<o:p></o:p>[/COLOR]
[COLOR=#1f497d]            If adoRS(0) & "" = Split(Range("A" & x).Value, " ")(0) Then<o:p></o:p>[/COLOR]
[COLOR=#1f497d]                Range(comments & x) = adoRS(2)<o:p></o:p>[/COLOR]
[COLOR=#1f497d]                adoRS.MoveNext<o:p></o:p>[/COLOR]
[COLOR=#1f497d]                If adoRS.EOF = True Then<o:p></o:p>[/COLOR]
[COLOR=#1f497d]                    Exit Do<o:p></o:p>[/COLOR]
[COLOR=#1f497d]                End If<o:p></o:p>[/COLOR]
[COLOR=#1f497d]                If adoRS(1) > 0 And adoRS.EOF <> True Then<o:p></o:p>[/COLOR]
[COLOR=#1f497d]                    Do While adoRS(1) <> 0<o:p></o:p>[/COLOR]
[COLOR=#1f497d]                        x = x + 1<o:p></o:p>[/COLOR]
[COLOR=#1f497d]                        Rows(x).EntireRow.Insert<o:p></o:p>[/COLOR]
[COLOR=#1f497d]                        Range("A" & x) = adoRS(0)<o:p></o:p>[/COLOR]
[COLOR=#1f497d]                        Range(comments & x) = adoRS(2)<o:p></o:p>[/COLOR]
[COLOR=#1f497d]                        adoRS.MoveNext<o:p></o:p>[/COLOR]
[COLOR=#1f497d]                        If adoRS.EOF = True Then<o:p></o:p>[/COLOR]
[COLOR=#1f497d]                            Exit Do<o:p></o:p>[/COLOR]
[COLOR=#1f497d]                        End If<o:p></o:p>[/COLOR]
[COLOR=#1f497d]           [/COLOR]

after adoRS(2) is converted to a string I need adoRS(2) i need to run a replace string as well. how coudl i run the following code on adoRS(2) after i have converted it?

string.replace(“=> “, “”).

Thank you so much for any help!