![]() ![]() Unfortunately, there is no line break or carriage return option in the dialog, which means that you’ll need to pick “Custom”, and enter the special character for a Line Feed:Įven worse, with entering this, Power Query is overly aggressive when you click OK. Right click the Text column –> Split Column –> By Delimiter.But if you select the cell, you’ll see in the preview window that all the data is there: Select the data –> create new query –> From TableĪt this point, you’d certainly be forgiven for thinking that only the first line was pulled in.In cell A3 type “This” –> Alt + Enter –> “is” –> Alt + Enter –> “text” –> EnterĪnd now we’ll go and pull it in to Power Query:.In cell A2, type “Text” and press Enter. ![]() To start with, let’s set up some simple data: Today’s post explores how we can split by line breaks in order to break these types of cell contents into multiple columns. Some more savvy Excel users know that you can break text onto multiple lines in a cell by pressing Alt+Enter mid entry.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |