inserting a hard return with replace in a cell

[Brent]

Is there a way to insert a hard return or line break using the replace
function in a cell?
Thanks
brent

 

[Dave Peterson]

Use char(10) in your =replace() function.

(and remember to turn wraptext on)

 

[Brent]

Thanks!

Use char(10) in your =replace() function.

(and remember to turn wraptext on)