Greeting,
I’m trying to submit a required state report as a text in certain format. I used Unidata to pull the required field as flat file[/url] and import the data to Excel 2007 successfully. The file has about 25 column (FName, MI, LName, SSN, DOB etc.)
The state wants the file formatted as, let’s say 5 spaces between FName and MI, and 4 spaces between MI and LName and 4 spaces between LName and SSN ,3 spaces between SSN and DOB etc. and submit it as a text without any file extension (so they can open the file using any text editor like NotPad.
What is the best way to accomplish the formatting?
Thank you in advance.
OCm[/FONT][/COLOR]
