Nanogirl21
Active Member
- Joined
- Nov 19, 2013
- Messages
- 330
- Office Version
- 365
- Platform
- Windows
I have cells that have multiple lines of data that is seperated by a return. Is there any way to break these returns into their own cells?
EXAMPLE:
CURRENT
<tbody>
</tbody>
<tbody>
</tbody>
EXAMPLE:
CURRENT
A1 | APPLES BANANAS GRAPES |
A2 | ORANGES MANGOS |
<tbody>
</tbody>
A1 | APPLES |
A2 | BANANAS |
A3 | GRAPES |
A4 | ORANGES |
A5 | MANGOS |
<tbody>
</tbody>