How to Hidden delete Automatic ENTER
PFA excel file and try removing enter from column B.
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.