[SIZE=1]let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Split = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByDelimiter("_", QuoteStyle.Csv), {"Column1.1", "Column1.2", "Column1.3", "Column1.4", "Column1.5"})
in
Split[/SIZE]
Column1 | Column1.1 | Column1.2 | Column1.3 | Column1.4 | Column1.5 | |
IN18059850_Plant_T0_1218_New Failure | IN18059850 | Plant | T0 | 1218 | New Failure |
A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | IN18059850_Plant_T0_1218_New Failure | IN18059850 | Plant | T0 | 1218 | New Failure |
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
Try:
A B C D E F 1 IN18059850_Plant_T0_1218_New Failure IN18059850 Plant T0 1218 New Failure
<tbody>
</tbody>Sheet1
Worksheet Formulas
Cell Formula B1 =TRIM(MID(SUBSTITUTE($A1,"_",REPT(" ",999)),COLUMNS($B1:B1)*999-998,999))
<tbody>
</tbody>
<tbody>
</tbody>