Forum Discussion
robwill100
Mar 04, 2021Brass Contributor
Entering line breaks using Char(10)
Hi all, I have a sheet where I want to input line breaks in certain cells. I am using th char(10) which is partially working however i was wondering if there is a way of combining char(10) and insert the line breaks after a delimiter such as a semicolon.
Also, is this something you could do in power query??
Any ideas woud be greatly appreciated.
Cheers
rob
1 Reply
Sort By
- Riny_van_EekelenPlatinum Contributor
robwill100 Not sure what you have in mind, but in PQ the equivalent of CHAR(10) would be #(lf). You can use it in "Replace values" or set it as the delimiter when you want to split or merge columns.