LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default 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
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
File saving problem fire_dragon09 Excel Discussion (Misc queries) 3 August 6th 07 08:35 PM
MS-Excel VBA file (XLA) saving problem Arvind Jagtap Setting up and Configuration of Excel 5 January 15th 07 03:45 PM
problem saving csv file CoyB Excel Discussion (Misc queries) 2 August 29th 06 04:31 PM
Problem saving the file after moving worksheets into another SteveD62226 Excel Discussion (Misc queries) 0 November 18th 05 10:01 PM
problem when saving CSV file mhe Excel Worksheet Functions 1 April 5th 05 07:45 PM


All times are GMT +1. The time now is 05:18 AM.

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

About Us

"It's about Microsoft Excel"