Removing quotation marks in a txt-file
 

Hi,
I have to remove quotation marks in a txt-file during a certain procedure.
How can I do it using excel-macro?

Removing quotation marks in a txt-file
 

First import the txt file into Excel.

Then enter and run:

Sub dont_quote_me()
Dim r As Range
For Each r In ActiveSheet.UsedRange
If r.PrefixCharacter = "'" Then
r.Value = r.Value
End If
Next
End Sub

Then save the file back as txt
--
Gary's Student


"Reedhill" wrote:

Hi,
I have to remove quotation marks in a txt-file during a certain procedure.
How can I do it using excel-macro?