Power Query: split column by delimiter with multiple spaces

Опубликовано: 14 Январь 2025
на канале: Karina Adcock

16,053

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: https://goo.gl/c46YPs

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 in excel - 7 methods
How to split text using a formula in excel    • How to split text using a formula in ...
How to make SPLIT formula in excel    • How to make SPLIT formula in excel