Using the Text-To-Column feature is adding extra columns

[shorti3413]

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.

[sweep]

Hi,

Do you have "Treat consecutive delimiters as one" ticked?

[shorti3413]

I typically don't have "Treat consecutive delimiters as one" check marked. However I have tried it both ways (with and without being check marked) and it seems to output the same results with the extra blank column in between each column with data. The only difference is that when it is check marked, it adds an extra blank column after the last column with data.

[ChemistB]

Can you upload some sample data (Go Advanced>Manage Attachments)
I thought for sure that Sweep had nailed that one.

[shorti3413]

I unfortunately cannot. The data I am trying to paste within excel is company information and cannot share that

[newdoverman]

I just used your example with Text to Columns.
I chose Delimited, then unchecked Tab and entered " in the Other box and selected Treat consecutive delimiters as one.
Clicked Next. The Data Preview showed a black column. I clicked on Do not import column (skip)
No excess columns were created.

	A
1	"data 1""data 2""data 3"

	A	B	C
1	data 1	data 2	data 3