Forum Discussion
Moving Text from Word to Excel
I have an interview transcription in Word that I would like to move into Excel. I would like each sentence to be in a differnt unique cell. Is there a fast way to do this? Ata
Simplest
Copy text from word and paste.
This will put every Paragraph in a different row/cell in column A
Then you can use the
https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7
Select entire Column A a goto
DATA-> Text to Columns.
Select Delimited -> Next.
Select the period (.) as you data delimiter
[Finish]
Now you have each Paragraph in a different row and each Sentence (- the full stop) in a separate cell.
Is this what you want? Or do you want the Sentence in a single column?
MindreVetande This is worth a try. Thank you Ata
