5 replies
by dklippert
Without going into detail about how you're importing the data, a rough piece of code might look like this:
Sub CleanData
Cells.Replace What:="""", Replacement:=""
End Sub
You might do better by changing the extention and then recording a macro as Excel parses the file.
Also look at:
by tgrignon
by pancras
You can place a value in cell a1 with
in current sheet
range("a1").value="Some text"
in sheet1 (not current sheet but current workbook)
sheets("sheet1").range("a1").value="some text"
"some text" can be in say a3 so
range("a1").value=Mid(Range("a3").Value, 2, Len(Range("a3").Value) - 2)
should do the trick
by tgrignon
by tgrignon
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending