Opening CSV file in column A?

H

Henrik

I have a .csv file where a few records are 'split' across multiple columns, I
presume because they have a comma (or similar) in them. All other records
remain in the A column.

That is annoying because Isubsequently need to manipulate all records in the
same way (using 'Text to Columns'and other manipulations). It is thus
essential that *all* records *stay* in the A column, i.e. that no 'Text to
column' type functionality engages immediately upon opening the csv file.

Is there a way to ensure this does not happen, i.e. that all records stay in
column A?

Thanks
 
D

David Biddulph

Rename the file from .csv to .txt.
Open it from within Excel as a delimited file, but unselect comma or any
other potential delimiter.
 
H

Henrik

Thanks, David, that works. It is of course a bit of a workaround -- is there
really no way to do this straight from a .txt file?
 
G

Gord Dibben

Henrik

Change the extension from .csv to .txt

Open that and the Text to Columns Wizard opens.

Choose to keep all data in column A.


Gord Dibben MS Excel MVP
 
D

Dave Peterson

The whole point of .csv files is so that text files can be easily imported into
excel in different columns.

If you really, really want to break this behavior, you could try this:

Look at the .csv file in notepad. Make a note of the field separator character.

Then make sure that windows regional settings doesn't use that character as the
list separator.

windows start button|settings|control panel|regional and language options
On the Regional Options tab
click the Customize button
On the numbers tab, check the list separator box.

But this sounds like a pretty strange requirement to me. In fact, I wouldn't
want you to mess with that setting on my pc.

It would screw up lots of things--including the way I enter a formula:

=if(a1=1,2,3)
would have to use that list separator that you chose.
 
D

Dave Peterson

If you do File|Open and select the .txt file (you wrote .txt in your response),
you can shift-click on the Open button and excel will put it all in column A.
 
Top