• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Import Text From MS Word

Gregg Wolin

Gregg Wolin

Member
I have a very long google chat that I want to import into a spreadsheet. I got the text into Word and it's formatted with carriage returns (paragraph breaks) each post. I want to import it so that each successive post shows up in alternating columns and rows so it sort-of looks like a chat would look. Thoughts?
 

Attachments

  • Screen Shot 2022-04-23 at 2.59.36 PM.png
    Screen Shot 2022-04-23 at 2.59.36 PM.png
    45.1 KB · Views: 7
You should loop the Document Paragraphs collection in order to grab the Range.Text property like you can see in Word VBA help …​
​
 
You must log in or register to reply here.
Back
Top