Moving Text from Word to Excel

New Contributor

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?



2 Replies



Copy text from word and paste. 

This will put every Paragraph in a different row/cell in column A

Then you can use the 


Select entire Column A a goto

DATA-> Text to Columns.
Select Delimited -> Next.
Select the period (.) as you data delimiter

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