Hello,

I am importing data from a site that when I paste the data into excel, it has all the information listed in a single column. I am aware that I have to use the Text-to-Column feature in excel to split the information up into several columns.

So when I click on the Text-to-Column option (or use the import wizard), on the first screen, I select DELIMITED and click Next. All of the data I am trying to import is separated with two quotations. For example... -> "data 1""data 2""data 3" <- So then on the next screen, I choose OTHER for the Delimiter Type and then add in a set of quotations. I click NEXT and FINISH

When I finish using the wizard, it has added an extra, blank column in between each column with data. So it is as if the text-to-column feature is working because it is separating the data however I was wondering if anyone knows how to not add the extra blank column?


Any help is appreciated! Thanks.