Moving Text from Word to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1900740%22%20slang%3D%22en-US%22%3EMoving%20Text%20from%20Word%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1900740%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20interview%20transcription%20in%20Word%20that%20I%20would%20like%20to%20move%20into%20Excel.%26nbsp%3B%20I%20would%20like%20each%20sentence%20to%20be%20in%20a%20differnt%20unique%20cell.%26nbsp%3B%20Is%20there%20a%20fast%20way%20to%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAta%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1900740%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1900833%22%20slang%3D%22en-US%22%3ERe%3A%20Moving%20Text%20from%20Word%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1900833%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F873388%22%20target%3D%22_blank%22%3E%40Atalissa%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESimplest%3C%2FP%3E%3CP%3ECopy%20text%20from%20word%20and%20paste.%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20will%20put%20every%20Paragraph%20in%20a%20different%20row%2Fcell%20in%20column%20A%3C%2FP%3E%3CP%3EThen%20you%20can%20use%20the%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fsplit-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Etext-to-columns-wizard%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESelect%20entire%20Column%20A%20a%20goto%3C%2FP%3E%3CP%3EDATA-%26gt%3B%20Text%20to%20Columns.%3CBR%20%2F%3ESelect%20%3CEM%3EDelimited%3C%2FEM%3E%20-%26gt%3B%20Next.%3CBR%20%2F%3ESelect%20the%20%3CEM%3Eperiod%3C%2FEM%3E%20(.)%20as%20you%20data%20delimiter%3CBR%20%2F%3E%5BFinish%5D%3C%2FP%3E%3CP%3ENow%20you%20have%20each%26nbsp%3BParagraph%20in%20a%20different%20row%20and%20each%20S%3CSPAN%3Eentence%20(-%20the%20full%20stop)%26nbsp%3Bin%20a%20separate%20cell.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIs%20this%20what%20you%20want%3F%20Or%20do%20you%20want%20the%26nbsp%3BSentence%20in%20a%20single%20column%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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?

 

Ata

2 Replies
Highlighted

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

Highlighted

@MindreVetande  This is worth a try.  Thank you Ata