Moving Text from Word to Excel

Copper 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?

 

Ata

2 Replies

@Atalissa 

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 

text-to-columns-wizard 

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