but skips ahead 10 charachters to go to the next line.
Are you sure that your source data doesn't have trailing spaces?

if the charachters in the cell are X(the X here is the big question)
You could check the LEN of the text in teh cell.