Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem saving as txt file
hello
i have following problem. i have following data: account amount description (usually inv. nos) 3456 55.66 334466 6785 122.12 45678, 98456 i concatenate it , add spaces so that all items are in fixed position, copy and paste special values to another sheet and save this sheet as txt file. problem is that some description fields contain commas and these lines in txt file begin with " character. so txt file looks like this: 3456 55.66 334466 "6785 122.12 45678, 98456 wich makes second line 1 character longer. I need all lines to be the same lenght. it only happens where there is comma in excel. is there a way to go around it. thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File saving problem | Excel Discussion (Misc queries) | |||
MS-Excel VBA file (XLA) saving problem | Setting up and Configuration of Excel | |||
problem saving csv file | Excel Discussion (Misc queries) | |||
Problem saving the file after moving worksheets into another | Excel Discussion (Misc queries) | |||
problem when saving CSV file | Excel Worksheet Functions |