Nanogirl21
Active Member
- Joined
- Nov 19, 2013
- Messages
- 330
- Office Version
- 365
- Platform
- Windows
I have a list of values that is seperated by a return. How do I sort each cell in alphabetical order without moving the row?
EXAMPLE.
CURRENT DATA
<tbody>
</tbody>
WANTED RESULTS
<tbody>
</tbody>
EXAMPLE.
CURRENT DATA
1 | APPLES GRAPES WATERMELON BANANA CHEERY |
2 | PINK BLUE GREEN YELLOW |
3 | APRIL AUGUST JULY DECEMBER JUNE |
<tbody>
</tbody>
WANTED RESULTS
1 | APPLES BANANA CHERRY GRAPES WATERMELON |
2 | BLUE GREEN PURPLE YELLOW |
3 | APRIL AUGUST JULY JUNE DECEMBER |
<tbody>
</tbody>
Last edited: