Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.

I have many separate list generated on a UI that are just separated by commas. Is there anyway I can make it so if I copy and paste those comma separated list into it excel it automatically puts ...