filmov
tv
Excel Power Query - Split Single cell string of names into separate row names & remove numbers
Показать описание
Welcome to my ExcelPowerTips Channel!
This Power Tip shows you how you can (without any Excel Formulas nor Excel VBA) to quickly split a long string of names separated by numbers in a single cell into separate names in separate rows with numbers and other characters stripped.
All with a few Excel steps using Excel's built-in Power Query Editor which has a huge number of Data Transformation Tools.
Enjoy!
Subscribe - Like - Share - Enjoy!
This Power Tip shows you how you can (without any Excel Formulas nor Excel VBA) to quickly split a long string of names separated by numbers in a single cell into separate names in separate rows with numbers and other characters stripped.
All with a few Excel steps using Excel's built-in Power Query Editor which has a huge number of Data Transformation Tools.
Enjoy!
Subscribe - Like - Share - Enjoy!
0:00:43
0:07:08
0:10:54
0:09:58
0:04:04
0:04:58
0:01:30
0:08:57
0:06:53
0:02:28
0:04:37
0:05:57
0:03:02
0:01:22
0:15:11
0:04:08
0:14:17
0:09:59
0:07:43
0:04:29
0:05:00
0:00:28
0:04:38
0:05:58