Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi there!
I have an Excel file with a series of fields, each in one column. What I need to do is determine a fixed length for each of these fields, so that when I export this file to a CSV file, I get a file in which each column has exactly the same fixed length. For example, if my Excel file contains: A B C 1234 ABC21 1234 and I want fields to have these fixed lengths: A - 5 B - 6 C - 4 my CSV file should contain: 1234 ;ABC21 ;1234 Any easy way of accomplishing this? I tried custom cells but when exporting, I lose the information. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) | |||
How do I export an excel file as fixed length records | Excel Discussion (Misc queries) | |||
Export to fixed width text file | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
How do I display leading zeros so I can export a fixed in Excel? | Excel Discussion (Misc queries) |