filmov
tv
Power Query: split column by delimiter with multiple spaces
Показать описание
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
Microsoft Office 365, 2016, Office Insider, Version 2007
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
---------------------------------------------------------------------------------
#exceltips #exceltutorials #powerquery
Microsoft Office 365, 2016, Office Insider, Version 2007
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: