Forum Discussion

Atalissa's avatar
Atalissa
Copper Contributor
Nov 18, 2020

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

excel

2 Replies

  • MindreVetande's avatar
    MindreVetande
    Iron Contributor
    Nov 18, 2020

    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 

    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?

Resources