One way:

http://www.mcgimpsey.com/excel/textf...tml#fixedfield


In article ,
"Plucky Duck" <Plucky wrote:

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.