How To Get Wrapping Tab Delimited Text File To Stay in Appropriate Rows

[Sky_]

Sorry all, I'm alright with excel fuctions but not sure how to handle unruly wrapping paragraphs. I have a text file with clearly tab delimited fields (ID, Last Name, First Name, etc) but the final section is 'Essay'. The essay field wraps around into the next row, thus making it impossible for my supervisor to work with the file. Is this something that would require a script to get the essay portion to stay under the 'Essay' Column or is there an easier way? Appreciate any and all help that could be provided. Thanks!

[natefarm]

Several things you can look at or try: At what point does the wrap occur? The Excel cell character limit is 37,767. Is that being exceeded? Is it actually wrapping to the next row, or just wrapping within the cell (which shouldn't be a problem)? Are there imbedded CR/LF characters in the file that could be causing it? (I don't see how there could be, if it's truly just a flat .txt file). In your steps for opening the file, in step 3 where it shows the columns, select the essay column and define it as Text instead of General, and see if that helps.