Entering line breaks using Char(10)

%3CLINGO-SUB%20id%3D%22lingo-sub-2183911%22%20slang%3D%22en-US%22%3EEntering%20line%20breaks%20using%20Char(10)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2183911%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20I%20have%20a%20sheet%20where%20I%20want%20to%20input%20line%20breaks%20in%20certain%20cells.%20I%20am%20using%20th%20char(10)%20which%20is%20partially%20working%20however%20i%20was%20wondering%20if%20there%20is%20a%20way%20of%20combining%20char(10)%20and%20insert%20the%20line%20breaks%20after%20a%20delimiter%20such%20as%20a%20semicolon.%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20is%20this%20something%20you%20could%20do%20in%20power%20query%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20woud%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Erob%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2183911%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

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

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