Importing and Exporting TXT files

[DianneL]

Hello,

I have a file that is I need to pull in and reformat for export.

It looks like this:
622113011234567890 0000123456789 DOEJOHNR 0 0000001

I need to import it and be able to kick it back out with set field widths and the end column needs to have a total of 16 zeros across.

How can I set the width of the columns for export back to .txt?

Thanks in advance for your help.

[Pete_UK]

If the column contains text, you can use the REPT function to add on leading spaces (maybe with the RIGHT function. If the column contains proper numbers, you can use the TEXT function with an appropriate format string.

Hope this helps.

Pete