Power Query " Split by Line feed" adds unwanted dash

[Pepe Le Mokko]

While working on this thread when I tried to split by line feed, the editor added an unwanted dash before #(lf)" like "-#(lf)" returning no result
Removing the dash did the trick but why is the editor adding this dash ?

[sandy666]

it doesn't add dash because it already exists, it just adds #(lf) to the existing dash (not replace)
you need to remove dash first and then use split using special character/Insert special character/Line feed

[JEC.]

Here is one more option for your query in the other topic

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    trf = Table.TransformColumns(Source,{{"Channel", each Text.Split(_, "#(lf)")}, {"Channel Date", each Text.Split(_, "#(lf)")}}),
    col = Table.AddColumn(trf, "Custom", each List.Zip({List.Repeat({[ID]},List.Count([Channel])),[Channel],[Channel Date]})),
    out = Table.FromRows(Table.ExpandListColumn(col, "Custom")[Custom])
in
    out