View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
shark102 shark102 is offline
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