Forum Discussion
Splitting Rows by Backspace
Are you sure your character is a backspace? That won't produce a new line. This is how you can split a cell to new rows by a carriage return/line feed (character 13):
Table.ExpandListColumn(Table.TransformColumns(Source, {{"Column1", Splitter.SplitTextByDelimiter("#(cr)#(lf)", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Column1")Interesting - what about this?
= Table.ExpandListColumn(Table.TransformColumns(#"Changed Type2", {{"Details.1", Splitter.SplitTextByDelimiter("#(lf)", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Details.1")
Super UserAre you sure your character is a backspace? That won't produce a new line. This is how you can split a cell to new rows by a carriage return/line feed (character 13):
Table.ExpandListColumn(Table.TransformColumns(Source, {{"Column1", Splitter.SplitTextByDelimiter("#(cr)#(lf)", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Column1")
Thank you for the suggestion!
unfortunately it didn’t work..is there a way to find the character for certain which separates the text?
- jennratten
Yes, there are a few ways. A quick and easy way is to click on a cell that has a line break, copy the text that appears in the preview, open a blank query and paste the text you copied into the formula bar and press enter. The text in the formula bar will change to display the characters.
Thank you! it worked!!!