Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV file with 13space characters in blank cells
In my office we've just received a recurring report
which has been modified (by someone. Previously (a CSV file) the Data area (say A1:M30 ) had numbers or blank cells representing 0 (zero) values. Now, however the blank cells ARE NOT BLANK (although they appear blank) all cells without numbers have 13 hard-space values in them, which is causing #VALUE! problems; I temporarily added an intermediate sheet with formula: =IF(ISNUMBER(VALUE(MySheet!B2)),MySheet!B2,0) to eliminate the #Value! problem; Is there a better way? I'm sure there is, just not certain at this point in time. Any input appreciated... TIA, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV file with 13space characters in blank cells
How about a Find and Replace? Click Edit Replace; enter thirteen
hard spaces in the FIND box and leave the REPLACE WITH box empty. Sometimes these cells come across with a leading apostrophe- let us know if yours does too. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV file with 13space characters in blank cells
Dave:
Thanks; How could I forget 'ye ole' Find and replace... Too Quickly resorted to a formula solution. I need to say someting to our IS dept about how these $0.00 values are getting converted to the 13 space characters. The leading apostrophe is not there. Tks again,, Jim "Dave O" wrote: How about a Find and Replace? Click Edit Replace; enter thirteen hard spaces in the FIND box and leave the REPLACE WITH box empty. Sometimes these cells come across with a leading apostrophe- let us know if yours does too. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
enter numbers in blank cells | Excel Worksheet Functions | |||
Formula to delete blank cells across multiple columns? | Excel Worksheet Functions | |||
Using text in cells to build a link to within another file | Excel Discussion (Misc queries) | |||
Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |