Manolocs
Active Member
- Joined
- Mar 28, 2008
- Messages
- 340
Hi, I know Text to Column option can be used to split text but split every word with a single space to different cell.
What I am looking for is a way to split a cell every time there are more than one space between the words.
In this case the strings are separated by more than 4 spaces
<tbody>
</tbody>
What I am looking for is a way to split a cell every time there are more than one space between the words.
In this case the strings are separated by more than 4 spaces
help mary. help john. help Louis | help mary | help john | help Louis |
Johny is walking. Andrew is sleeping | Johny is walking | Andrew is sleeping |
<tbody>
</tbody>