Apr 12 2022 05:05 PM
I have a large sum of data from a word document I need to copy and paste into excel. An example of the format is below (don’t worry it’s not actually children’s rhymes):
roses are red
violets are blue
sugar is sweet
and so are you
chicken wing
chicken wing
hot dog and bologna
cheese and macaroni
I have pages and pages of data formatted in this way and I am currently having to copy and paste each chunk directly and individually from the word doc into a singular cell. It would be ideal if I could copy and paste the text from the whole document into a cell and use text to cell with a custom/other delimiter to separate it out into cells based on the paragraph break between each chunk of text. I have tried ctrl + j and that separates the data by each line rather than each chunk. So for example I would have “roses are red” & “violets are blue” in two separate cells rather than having each poem in its own cell.
Any ideas? Thanks
Apr 13 2022 12:04 AM
It would help if you made a small sample document available through OneDrive, Google Drive, Dropbox or similar.
Apr 13 2022 05:41 AM
Apr 13 2022 01:02 PM