LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 9
Default SOLVED importing cvs file!!

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 "-"

example:

-3.543
0.392
--2.274

This gives problems importing. Resulting in:

-3,543
0,392
2,274

Any ideas how to solve this!!

Have attached the cvs file!!

SOLVED IT … had to import cvs to A:A (TEXT) then Replace "--" with "-" and then use text to columns.
Attached Files
File Type: zip 205FDB_PROFILE1_20121102060003_003.CSV.zip (16.9 KB, 32 views)

Last edited by kima : November 5th 12 at 12:37 AM
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Modify The Code For Importing Text File into an Excel File vicky Excel Programming 1 December 28th 09 09:47 AM
Importing a file..then saving back to original file HarveyM.[_2_] Excel Programming 1 January 16th 09 01:57 PM
Importing a file(s) dan Excel Worksheet Functions 1 August 10th 06 04:08 AM
Importing a file Dan Excel Programming 2 August 9th 06 02:42 PM
Importing text file, only option to edit existing file smokey99 Excel Discussion (Misc queries) 8 April 26th 06 09:08 PM


All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"