I'm trying to figure out how I can automate parsing out cells that have multiple line items entered into it -- out into a row per item. Example content. The following is all in one cell and I have many of these. How do I find the hard return in order to break them out into different rows.
ActiveCell = B2
* Interoperability: Address operating in a high matrix environment <ALT-ENTER>
* Finance: Underlying requirements for SOW <ALT-ENTER>
* Change Mgmt.: Navigate constant changes to work more effectively
I want to insert blank rows below this cell and break out each line out to a single row / cell for each underneath it
B3 = * Interoperability: Address operating in a high matrix environment
B4 = * Finance: Underlying requirements for SOW
B5 = * Change Mgmt.: Navigate constant changes to work more effectively
ActiveCell = B2
* Interoperability: Address operating in a high matrix environment <ALT-ENTER>
* Finance: Underlying requirements for SOW <ALT-ENTER>
* Change Mgmt.: Navigate constant changes to work more effectively
I want to insert blank rows below this cell and break out each line out to a single row / cell for each underneath it
B3 = * Interoperability: Address operating in a high matrix environment
B4 = * Finance: Underlying requirements for SOW
B5 = * Change Mgmt.: Navigate constant changes to work more effectively