I copy data from a PDF and I would like each line to be pasted all into the same "A" column, because then I have a macro that does all the splitting work into columns that works fine.
On my computer, Excel sticks to a single column as soon as I copy it from the PDF, but on the PC that will use the spreadsheet today, I started to paste one part into column A and divide the rest into columns B, C, and D, until yesterday it was pasted in column A.
Does anyone know how to force everything to be pasted only in column A?
