Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saved *.csv file gives SYLK file type warning upon Excel 2003 open | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
CSV file containing german characters imported into Excel | Excel Discussion (Misc queries) | |||
Refresh Imported Data - Does the Excel file have to be open? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |