Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to import .csv files into excel. Problem is that the program
that exports the .csv files comma sepatates the values and the values themselves contain commas. For example: 3,14,-1,28,0,74 Should be interpreted as: 3,14 -1,28 0,74 The only thing I have going for me is that all the values contain commas. This means I should be able to replace every second comma with another delimiter and thus be able to read the file correctly. Something like this: 3,14;-1,28;0,74 Iīve been thinking about how to go about this but havenīt been able to come up with anything that works. Does anyone have any suggestions on how to replace every second comma in a string? Regards / Thomas L |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
removing the "-" sign in a calucation | Excel Worksheet Functions | |||
Removing beginning minus sign from telephone numbers | Excel Discussion (Misc queries) | |||
Removing % sign, but keeping the formatting | Excel Discussion (Misc queries) | |||
removing comma | Excel Worksheet Functions | |||
Removing a space after a comma | New Users to Excel |