put each value in different column

Copper Contributor

Hi i have exported a list of active users on 365 admin

and i want to see each licences in different column

is there a way to do it?

 

1 Reply
Did you try the function under the Data tab called Text to Columns? That gives a lot of options how to parse text.