I need a function for separating wrapped text in a cell to columns as shown in the attached file. You can propose a macro for obtaining this if it cannot be accomplished through a function.
I am working with Excel 2010 so the function or macro must be compatible with it.
Please review the attached Excel file. The "Original Page" is how the data is originally formatted, and the "Results Page" is how the data data should look after it is converted to columns.
Please let me know if you have any questions. Thank you.