15K views · 104 reactions | Break down text into individual characters using M code in Power Query! let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], Splittext = Table.AddColumn(Source, "Splitext", each Text.ToList([Name])), Expandcolumn = Table.ExpandListColumn(Splittext, "Splitext") in Expandcolumn This splits each letter in the "Name" column into separate rows.  #PowerQuery #Excel #DataTransformation | Excel By Vikal | Facebook
2:19
15K views · 104 reactions | Break down text into individual characte…
4.1K views3 weeks ago
FacebookExcel By Vikal
Extract Letters, Numbers, Symbols from Strings in Power Query with Text.Select and Text.Remove • My Online Training Hub
Extract Letters, Numbers, Symbols from Strings in Power Query with …
May 13, 2021
myonlinetraininghub.com
Remove or Extract Special Characters from a data set using Power Query - XL n CAD
Remove or Extract Special Characters from a data set using …
May 23, 2020
xlncad.com
Split Letters & Numbers Like a Pro! - Power Query Challenge 59
Split Letters & Numbers Like a Pro! - Power Query Challenge 59
494 views10 months ago
YouTubeHow to Learn Excel
Combining text from cells in the same column in Power Query without combining the whole rows T0031
Combining text from cells in the same column in Power Query with…
7.9K viewsAug 24, 2022
YouTubeCelia Alves - Solve & Excel
Extract Parts of a Text Value in Power BI using a Delimiter: Power Query Transformation
Extract Parts of a Text Value in Power BI using a Delimiter: Powe…
Jun 8, 2021
radacad.com
How to use Microsoft Power Query
16:35
How to use Microsoft Power Query
3M viewsNov 24, 2020
YouTubeKevin Stratvert
5:47
Advanced Excel Power Query | Text Functions | Tutorialspoint
188.4K viewsOct 10, 2019
YouTubeTutorialsPoint
2:57
How to use Excel’s Power Query Editor | Microsoft
35.6K viewsMay 24, 2021
YouTubeMicrosoft Helps
3:39
How to insert special character at every cell in Excel
170.2K viewsMay 8, 2015
YouTubevidplayer
10:12
Clean and Extract Text the EASY Way - Pro Tip!
42.1K viewsMay 13, 2021
YouTubeMyOnlineTrainingHub
9:24
34 - Useful Text Functions in Power Query
26.2K viewsApr 2, 2020
YouTubeTrumpExcel
8:57
Split Data Into Rows Using Power Query
58.8K viewsNov 5, 2020
YouTubeExcel Campus - Jon
14:00
Use Power Query To Import Text File into Excel
5.9K viewsApr 28, 2020
YouTubeSean Johnson
10:01
3 Quick Ways To Combine Text In Excel - Formulas
56K viewsJun 17, 2021
YouTubeExcel Campus - Jon
5:42
20 - Replace Values in Power Query in Excel
30.9K viewsApr 2, 2020
YouTubeTrumpExcel
12:49
How to Extract Numbers from Text in Excel | 3 Methods - Power Quer…
124.2K viewsApr 13, 2021
YouTubeChester Tugwell
5:43
Select Columns based on Excel Table | Power Query
9.5K viewsMar 26, 2021
YouTubeExcel Newb
3:02
Replace text with another column value in Power Query
41.2K viewsJun 22, 2021
YouTubeCurbal
15:58
Multiple Key Words Search with Power Query
36.5K viewsApr 23, 2020
YouTubeDoug H
11:50
15 Power Query Shortcuts For Excel And Power Bi
15K viewsApr 8, 2021
YouTubeExcel Campus - Jon
5:58
28 - Transform Text with Extract Options in Power Query
20K viewsApr 2, 2020
YouTubeTrumpExcel
2:03
How to Extract Text Before or After a Specific Character in a String in …
81.6K viewsJan 11, 2021
YouTubeFind Easy Solution
7:17
Using Power Query for Text to Columns and Rows - CRUSHES E…
8.6K viewsSep 17, 2019
YouTubeKnack Training
7:09
Power Query: Combine rows into a single cell with Text.Combine
48.8K viewsApr 17, 2020
YouTubeExcel On Fire (Oz du Soleil)
4:24
Concatenate Text Values using Group by in Power Query (w/ Opti…
47.8K viewsDec 28, 2020
YouTubeBI Gorilla
3:04
11.6 How to Extract Text with Delimiters in Power BI (Power Que…
46.8K viewsAug 4, 2020
YouTubePavan Lalwani
3:09
Insert text anywhere in a cell without adding a new column using the Po…
33.7K viewsJun 29, 2020
YouTubeCurbal
12:29
Get all possible combinations from multiple lists in Excel using Powe…
97.4K viewsFeb 14, 2021
YouTubeExcel Off The Grid
5:48
Extract Text in Power Query
26.1K viewsJan 10, 2022
YouTubeDoug H
See more videos
Static thumbnail place holder