Flashheart
|
|
« on: Monday, December 2, 2019, 13:36:15 » |
|
There's probably an easy answer to this that I've missed, but...
I often have information (articles) written in word documents that I need to transfer to excel. The information needs to be added from left to right in separate cells. The articles are a fixed format so there's a fixed number of headers and paragraphs with the corresponding number of cells in excel.
When I copy and paste, excel separates paragraphs and puts them into separate cells, which is exactly what I want, except... It only copies them doing down the page row by row, but I need it to paste across the page.
I've been copying and pasting one by one, but there must be an easier solution. Right?
|
|
|
Logged
|
|
|
|
RobertT
Offline
Posts: 11717
|
|
« Reply #1 on: Monday, December 2, 2019, 15:37:39 » |
|
If you are simply asking it to paste from vertical to horizontal, then Paste Special, click Transpose?
|
|
|
Logged
|
|
|
|
Flashheart
|
|
« Reply #2 on: Monday, December 2, 2019, 15:42:21 » |
|
It doesn't give me that option.
|
|
|
Logged
|
|
|
|
4D
Or not 4D that is the question
Offline
Posts: 21922
I can't bear it 🙄
|
|
« Reply #3 on: Monday, December 2, 2019, 16:07:34 » |
|
I think the only way to do it is copy it across to a spare excel page, then from that data copy to where you want it in excel and paste special ticking "transpose"
|
|
|
Logged
|
|
|
|
jayohaitchenn
Wielder of the BANHAMMER
Offline
Posts: 12523
|
|
« Reply #4 on: Monday, December 2, 2019, 16:12:26 » |
|
|
|
|
Logged
|
|
|
|
Flashheart
|
|
« Reply #5 on: Monday, December 2, 2019, 16:20:10 » |
|
OK, will try that.
Thanks
|
|
|
Logged
|
|
|
|
4D
Or not 4D that is the question
Offline
Posts: 21922
I can't bear it 🙄
|
|
« Reply #6 on: Monday, December 2, 2019, 16:22:20 » |
|
I answered a question correctly? We're gonna win the league.
|
|
|
Logged
|
|
|
|
STFC_Manc
Offline
Posts: 1533
|
|
« Reply #7 on: Monday, December 2, 2019, 19:20:10 » |
|
I might have misunderstood but I would copy all the information into Excel. Then use the text to columns function under data, then fixed width to separate the row into the right columns
|
|
|
Logged
|
|
|
|
Ginginho
Offline
Posts: 6856
|
|
« Reply #8 on: Monday, December 2, 2019, 19:47:49 » |
|
Text to columns as STFC_Manc says should do the trick
|
|
|
Logged
|
|
|
|
pauld
Aaron Aardvark
Offline
Posts: 25436
Absolute Calamity!
|
|
« Reply #9 on: Monday, December 2, 2019, 20:38:12 » |
|
I answered a question correctly? We're gonna win the league. Truly the end times are upon us!
|
|
|
Logged
|
|
|
|
|