How to Split Columns in Power Query
In this video I will show you How you can Split Columns in Power Query and after using this you will never use the excel method of text to columns and defining the delimeter and then it will ask you to replace the data in case the data is there in the columns.
I have tried to use the most common characters to test it out. You can do the testing on your data and please do let me know in the comments How much time you saved by using this feature.