You would have to have a formula like
=A1 & rept(" ",8-len(A1))
and use it on all of the cells in the workbook - basically create a 2nd sheet that mirrors the 1st sheet but using the formula as above to pad out to 8 characters. Then, simply save the formula sheet as .csv
Rgds, Geoff [blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
Thank you for this helpful hint. Sometimes the people you export files to don't want to change!
I had to go further and make sure the decimal places were preserved.
allows a save of a fixed length comma delimited file
G: Format([GAL],"0.000"
GALLONS: Left(" ",(8-Len([G])))+[G]+" "
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.