Copy flat file without format change in excel

[jbesclapez]

Hi there!

I have a long flat file in which I will later use VBA to replace some stings with other strings.

I can not find a way how to import the flat file as is, in excel.
I mean, it should not touch anything or create any column. The source should not be changed even with quotes, double quotes, comma... any tab separation... etc...
it should simply clone the exact content of the flat file first line into cell A1, then do second line as cell A2.... etc...

How do we do this "simple" task?

Thansk

 

[jbesclapez]

I think i got it working. It was too simple to be true ... but when you do not know... you do not know...

Basically simple copy a character in cell A1 then Open the dialog box for TexttoCOlumns and disable all Delimiters.
Now you can copy your text format. It should be good!

Cheers