How to Hidden delete Automatic ENTER

for Ex: copy any cell from B14 to B18 and try pasting in notepad, you will be observing cursor going to next line. This is because of enter present in cell.
So your task has to remove ENTER from this column from B9 - B18 if cell has no value.