lets say i have a string like this
string = "david,a1, a2, ""a3,a4,a5,a6"",a7,a8"
i want to replace the two double quotes with a single quote like this
string = "david,a1, a2, "a3,a4,a5,a6",a7,a8"
any idea on how to do this in vba.......for some reason i cant figure it out
Bookmarks