Hello,
I was wondering if there is a way to cut words from sentences ? My problem is that i have information that is in one cell and i need to cut it apart in different cells. I could do it manualy but there are thousands of sheets like this.
Example
Johan dohan, snippersnapper, jorgen 21, fasaani
And i need to get it in different cell cutting from every comma.
Johan dohan
snippersnapper
jorgen 21
fasaani
Thanks
I was wondering if there is a way to cut words from sentences ? My problem is that i have information that is in one cell and i need to cut it apart in different cells. I could do it manualy but there are thousands of sheets like this.
Example
Johan dohan, snippersnapper, jorgen 21, fasaani
And i need to get it in different cell cutting from every comma.
Johan dohan
snippersnapper
jorgen 21
fasaani
Thanks