How to paste text in the same Excel column?

Asked

Viewed 380 times

0

I copy data from a PDF and would like each row to be pasted all in the same column "A", because then I have a macro that does all the work of dividing into columns that works very well.

On my computer Excel pastes in a single column, as soon as I copy the PDF, but in the PC of those who will use the spreadsheet today started to paste a part in column A and divides the rest into columns B, C and D, until yesterday it pasted in column A.

Does anyone know how to force everything to be glued to column A only?

excel vba

1 answer

0

The special gluing option might suit the procedure...

Word - Opções de Colagem

  • I don’t want to convert row to column, I want each row of the PDF to stay only in column A. Before it pasted in one column. Now every time you glue it already uses the columns A, B, C and D.

Browser other questions tagged excel vba

You are not signed in. Login or sign up in order to post.