Hi All,

I'm working on a data-set from somebody else which has a description column. To import this into our operating system i need to convert to txt (tab delimited) - not usually a problem.

For some reason, whenever i convert this particular file, some of the summary's get broken out with half of the summary being moved on the line below.

I've replaced all line breaks, trimmed cells, removed any text which looks like code incase that was causing issues to no effect. There is no common character which seperates the summaries, some are broken with a " as the first symbol, some a space, some right in the middle of a word. As far as i can tell, there is nothing different about these cells than any of the ones which are converting to TXT without an issue?!

I'm afraid i can't post a sample as its confidential data

Any ideas?! i'm pulling my hair out here!

Many thanks

BB