Removing quotation marks in a txt-file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have to remove quotation marks in a txt-file during a certain procedure.
How can I do it using excel-macro?
 
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
 
Back
Top