Nov 18 2020 06:05 AM
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
Nov 18 2020 06:21 AM
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
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?
Nov 18 2020 06:26 AM
@MindreVetande This is worth a try. Thank you Ata