put each value in different column

%3CLINGO-SUB%20id%3D%22lingo-sub-1610235%22%20slang%3D%22en-US%22%3Eput%20each%20value%20in%20different%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1610235%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20i%20have%20exported%20a%20list%20of%20active%20users%20on%20365%20admin%3C%2FP%3E%3CP%3Eand%20i%20want%20to%20see%20each%20licences%20in%20different%26nbsp%3Bcolumn%3C%2FP%3E%3CP%3Eis%20there%20a%20way%20to%20do%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1610390%22%20slang%3D%22en-US%22%3ERE%3A%20put%20each%20value%20in%20different%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1610390%22%20slang%3D%22en-US%22%3EDid%20you%20try%20the%20function%20under%20the%20Data%20tab%20called%20Text%20to%20Columns%3F%20That%20gives%20a%20lot%20of%20options%20how%20to%20parse%20text.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted
Did you try the function under the Data tab called Text to Columns? That gives a lot of options how to parse text.