All

I have an Excel sheet that I need to be able to export in a particular way -
This will be extracted to a text file (csv).

What I need to be able to do is apply the following criteria to the data before
it is extracted. If any data within column C is over 20 characters long only
export the first 20 characters. Also, if the data is less than 20 - for
example 7 apply 13 spaces to the data to ensure that 20 characters worth are
extracted in the csv file.

Appreciate any help you can offer. thanks - Al ( )