Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
kima wrote:
I get some number from a measuring station i a cvs file. But they have made a programming fault making some of the negative results arriving with "--" instead of "-" [snip] SOLVED IT … had to import cvs to A:A (TEXT) then Replace "--" with "-" and then use text to columns. In the future, just open the CVS file in your text editor of choice and do the replacing there *before* opening in Excel. -- So, you're saying that if I can trick all the other mindless drones into believing that I subscribe to their arbitrary moral framework, they'll just leave me alone? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Modify The Code For Importing Text File into an Excel File | Excel Programming | |||
Importing a file..then saving back to original file | Excel Programming | |||
Importing a file(s) | Excel Worksheet Functions | |||
Importing a file | Excel Programming | |||
Importing text file, only option to edit existing file | Excel Discussion (Misc queries) |