Simple Paste question- please help!

C

CXIV

Sorry all i'm brand new to excel and these seems like it should be s
simple :(

my data looks like this in pdf file:
J02NA
J18BD
J1GXX
J2E4E
J2KDI
J2KEO
J2T7V
J2T9W
J2T9Y
J2V3X

BUT WHEN I COPY AND PASTE INTO EXCEL IT LOOKS LIKE THIS (4 rows):

J02NA J18BD J1GXX J2E4E J2KDI J2KEO
J2T7V
J2T9W J2T9Y
J2V3X

how do i paste my data correctly or what next steps can i do so the dat
pasted looks the same in excel aka 10 rows in 1 column??

I really appreciate who ever takes the time to answer this. it will hel
alot! Happy Easter/ Passover etc :) Thank you in advanc
 
S

Spencer101

CXIV;1600606 said:
Sorry all i'm brand new to excel and these seems like it should be s
simple :(

my data looks like this in pdf file:
J02NA
J18BD
J1GXX
J2E4E
J2KDI
J2KEO
J2T7V
J2T9W
J2T9Y
J2V3X

BUT WHEN I COPY AND PASTE INTO EXCEL IT LOOKS LIKE THIS (4 rows):

J02NA J18BD J1GXX J2E4E J2KDI J2KEO
J2T7V
J2T9W J2T9Y
J2V3X

how do i paste my data correctly or what next steps can i do so the dat
pasted looks the same in excel aka 10 rows in 1 column??

I really appreciate who ever takes the time to answer this. it will hel
alot! Happy Easter/ Passover etc :) Thank you in advance
Click to expand...

If you use "paste special / values" Does that make any difference
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to paste this down? 3
Copy/Paste (Clipboard) Issues 1
Graphing Question: Blank Lines Problem ? 2
Creating sheets with pasted colour-marked rows through a nifty macro command, please 1
Look Up Formula With Veried Search Range 2
Collating columns and rows to one columns 5
Need help creating macros 6
Filtering out duplicate entries? 0

Top