Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
280
Views
Topic starter
I would like to use split on 1 column into 4. There are about 50 spaces before the first string. How to use in power Query?
Is there a "Treat consecutive delimiters as one" feature or formula?
Thanks in advance.
Posted : 21/02/2017 6:16 pm
No, there isn't the same 'Treat consecutive delimiters as one' feature that we have in Excel, but you can first split by a fixed width to get rid of the blank spaces at the beginning of the string.
Mynda
Posted : 21/02/2017 8:33 pm
