Saving *.csv files

[Tom]

When I save the csv files and then have the data in the
csv files imported, I only get 8 characters in some
columns. For example, if a lastname is Smitherington, I
get Smitheri, thereby leaving out the 'ngton'. This does
not occur on the first column but does occur on the later
columns, like BA etc.
Is there a way to force the columns to be 'as wide' as
the greatest width of the data IN that column?
TIA,

 

[Bernie Deitrick]

Tom,

You don't say if your problem is on the export to the CSV file, or the
import from the CSV file.

If it is on export, try autowidth on all your coluns. If that doesn't work,
you could use a macro to write the data out to the file.

I have no idea what could be interfering with the import of CSV data, unless
you are really importing it as fixed width....

HTH,
Bernie
MS Excel MVP

 

[Dave Peterson]

And just to add to Bernie's reply:

I bet you're actually looking at the data after you've re-imported it into
excel. If you open the .csv file with NotePad, you'll see what it really looks
like.

(I've never seen .csv files chop cells like this--but .prn's do!)