• 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.

Data Formatting

D

Dano

New Member
Need some help? After importing data from any file type, i.e. word, pdf, txt, htm, etc. I'm trying to have all of the text data in one column & create multiple rows that separate the sentences. Purpose is to evaluate written data normally in .doc or .pdf format from excel. Thanks.
 
Hi ,

What happens when you select the text from say a Word document , copy it , and paste it in an Excel worksheet ?

Narayan
 
It spreads across multiple columns in which I wrap text to keep it under one column. But then I end up with various cells/rows that have paragraphs in one cell. Trying to split the cells so all of the sentences end up in separate and multiple rows. Thanks
 
You must log in or register to reply here.
Back
Top