forcing end of line character in google sheets -


is there way force cells in google sheet end 'enter'? if i'm updating sheet, can input string in cell a1 ... use right arrow move b1. preferable because entering string , pressing enter moves selection cell down a2 instead of across. problem without invisible 'enter' marker, messes formatting when combining cells via scripts.

i below...

setaddress(street.trim()+'\n'+ city.trim()); 

\n new line character.
street.trim() trim new line characters if there any.


Comments

Popular posts from this blog

javascript - WinJS appendTextAsync producing scheduler errors -

minify - Minimizing css files -

Sockets with kotlin -