A carriage return is often found (with XLS) als the character \n (sometimes txt files have \r)
When you import the test.xls with
data=Flatten[ Import["test.xls"],1]
data//Grid
Now if you want the second column that contains text with some \n characters you can select the row and delete all the carriage returns with
Map[StringReplace[#, "\n" -> ""] &, data[[All, 2]]]
{row 1And here is some text.And some more,row 2And here is some text.And some more,row 3And here is some text.And some more,row 4And here is some text.And some more,row 5And here is some text.And some more,row 6And here is some text.And some more}
Hope this helps.
Attachments:
