After copying and pasting from a pdf file, the copied text are split up into different rows. which I have to edit so that the text belonging to the same sentence are into one cell. I would be please if someone can show me how to create a macro that will allow me to join the text into a single cell.