1. Replace all spaces with "|" symbols, 2. Replace "||" with "|" until there is only one pipe symbol left, 3. Split columns by custom delimiter
---------------------------------------------------------------------------------
#exceltips #exceltutorials #powerquery
SUBSCRIBE: [ Ссылка ]
Microsoft Office 365, 2016, Office Insider, Version 2007
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
- How to split text in excel - 7 methods [ Ссылка ]
- How to split text using a formula in excel [ Ссылка ]
- How to make SPLIT formula in excel [ Ссылка ]
Power Query: split column by delimiter with multiple spaces
Теги
split text power querysplit columns by delimitersplit column by delimitersplit column multiple spacesmultiple spaces split column power querysplit columns by delimiter in power query when you have multiple spacesHow to split a column in power query with multiple spacestreat consecutive delimiters as onepower query split data into multiple columnssplit columns in power query with variable delimiterssplit columns with variable delimiters in power query