Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I have a CSV file that should be comma delimited the thing is that the program that creates it, creates it in two columns (if you open it in excel) I want to write (or pay for) a Marco that will pull the data, remove the column (if it's a tab, space, comma. then it should read the file and place a comma after x amount of characters. once that's done it should remove all the space on the right, so data, data , data,,, .data -- should look like data,data,data,data. I don't know how to do this. any help is appreciated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Import comma delimited text | Excel Discussion (Misc queries) | |||
Worksheet Row Change event | Excel Discussion (Misc queries) | |||
How can I change the default 'comma' format. Eg paranthesis inste. | Excel Discussion (Misc queries) | |||
how do I create comma and double quote delimited file | Excel Discussion (Misc queries) | |||
Time Stamp without change | Excel Discussion (Misc queries) |