Using the Import/Export Wizard, when you get to "Select Source Tables and Views" screen in the grid slid over to transform for the items selected and check the output size for the column. You should be able to adjust, sorry I don't know if Excel has a limit but text I am pretty sure does not. Press ok and try the export again.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)