"line break" in cells

[ElPazzo]

Hi,

I have some "line breaks" in cells I cannot define. The text in the cells looks normal but there is a break in it. I know it because when copying the cells to an sql query in management studio, the line is broken to a new one at the end of the cell and because the cell content should be unique but some seem like duplicates. how to find out which kind for break it is in order to replace it?

here are some examples of such duplicate cells put between ''

'iwwerliewenschancen'
'iwwerliewenschancen
'

as you can see the second one contains a break...


thx for the help,
Pascal

edit: never mind, the splits was saved by a script, that didn't replace them as it should. fixed that part and got rid of the breaks in the cells.