power query to insert dashes into text. flash fill too! excel magic trick 1638

Published 4 years ago • 8.9K plays • Length 3:44

Download video MP4
Download video MP3

Similar videos

6:45

flash fill, array formula or power query? to insert dash between text & number. emt 1641
2:36

replace function to insert a dash into text. flash fill too. excel magic trick 1639
12:18

remove numbers from text. flash fill, power query, formula or let function? excel magic trick 1670
11:46

excel magic trick 1356: lookup 3 items & return to single cell helper column or power query?
14:14

excel magic trick 1334: power query or formula: lookup name based on max value and more…
3:32

textjoin & mid? left, 2 mid, right? excel formulas to insert dashes into text excel magic trick 1637
4:23

excel magic trick 1183: remove all text after dash: flash fill, text to columns, text formula
11:38

excel - power query import and clean fixed width text files - episode 2539
13:23

list.accumulate case study in power query
10:18

combine files from a folder with power query the right way!
1:17:24

master lists in power query: the ultimate guide to efficient data transformation
4:07

excel formulas, text to columns or power query to fix dates. excel magic trick 1790
14:25

mr excel & excelisfun trick 185: get text between first & last dash: 4 methods
5:52

excel magic trick 1441 power query to extract items in list 1 that are not in list 2: left anti join
6:07

excel magic trick 1414: power query text.padstart function to correctly format account numbers
5:04

add text numbers from description: power query or excel worksheet formula? excel magic trick 1721
8:00

excel magic trick 1437: dax query or logical test in operator: pull sales team data to excel sheet
9:15

excel magic trick 1423: power query number.totext function to format numbers as text
6:55

excel magic trick 1328: case sensitive filtering, adding or counting: power query (get & transform)
10:59

excel magic trick 1475: power query, formula, flash fill: "1-psd/afx-12" into "12-afx/psd-1"
3:02

excel text to columns or split to rows: worksheet formula or power query? excel magic trick 1795
4:14

excel hack video: power query to fix files in windows explorer? excel magic trick 1759

Clip.africa.com - Privacy-policy