View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JMay
 
Posts: n/a
Default CSV file Imported to Excel

I rec'd a CSV file today @ work. From Excel I did a File, Open and it opened
immediately (without the File Open Wizard which I was hoping for). Anyway,
everything LOOKED fine in the Range of numbers between B2 and K30 - with 20 or
30 blank cell among the numbers; I later
found out the blank cells WERE NOT Blank, but rather had 13 hard-coded space
characters in them.

I later opend the file in Word Pad and saw how that it appeared something like
as follows:

4344.56, 3232.56, , 555.55,

Where in excel it was:
B C D E
2 4,344.56 3,232.56 "13spaces" 555.55

This situation SHOULD be corrected before it gets to the end user, but what
should be done to eliminate the fields creating the 13 spaces versus a null
string ""?
Thanks in advance,,
Jim