I'm new to Excel vba programming, so I'm not sure if I'm doing the
right thing.

In my macro, if I do:

'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''

Dim fileName As String
Dim colIndex As Integer
Dim rwIndex As Integer

fileName = "test.txt"
colIndex = 4

Open fileName For Output As #1

For rwIndex = 2 To 10
Print #1, Cells(rwIndex, colIndex).Value
Next rwIndex

close #1

'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''

What I got in the output file were lines that ended with "^M". How can
I remove these characters?

Thanks