LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
NaughtonNJ
 
Posts: n/a
Default Changing fixed width (column break) defaults when importing text

I run the same reports for numerous accounts, month after month. The report
is always in text and is opened in Excel. I then need to use Fixed Width to
break it up into the proper column widths. The column width pattern is the
same every time(for example, 10 characters then 27 characters then 13
characters, etc) . With every report, I need to Change, Delete, and Move the
default break lines. Since I do this so often with the same report, does
anyone know how to set up the break lines so they default to the widths that
I need? The entire department will be very grateful as we all suffer from
having to do this. Thank you very much.
 
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
Resize individual cells w/o changing the entire column width Mary Ann Excel Discussion (Misc queries) 3 April 28th 06 04:39 PM
parsing text in a multiple column count JK57 Excel Worksheet Functions 3 April 13th 06 11:03 AM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
Count Position of Filtered TEXT cells in a column Sam via OfficeKB.com Excel Worksheet Functions 8 May 18th 05 04:23 AM
Export to fixed width text file FinChase Excel Discussion (Misc queries) 0 January 24th 05 07:25 PM


All times are GMT +1. The time now is 03:16 AM.

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

About Us

"It's about Microsoft Excel"