Entering line breaks using Char(10)

[robwill100]

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

[#2]

@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.