If you are using SSMS to get teh results and are using grid mode you can just copy and paste into Excel. You can also do File - Save Results As and save as a CSV. Then finally you can do Query - Results to File which creates an .rpt file which is a fixed width file.