Adding Line-Breaks in an Excel Cell: Using CHAR and SUBSTITUTE
In the previous video I showed how to retrieve Word data and bring it into Excel. However, Nisha in Chicago noticed that the original data was in lists, but I didn't retain the lists when the data was brought into Excel.
(The original video:
• Transferring Data from a Word Table a... )
Nisha asked, what it would take to get the data into lists.
In this video I use the functions CHAR and SUBSTITUTE to insert line-breaks. Also, "wrap text" is required so that Excel can display the data in lists.
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...
My blog: http://datascopic.net/blog-2-2