New answers tagged google-sheets-arrayformula
0
votes
Is there away on google sheets to paste text and automaticly create new rows with every line break or etc?
Basic Formula
=SPLIT(A2, ";")
Will SPLIT the string in A2 into a new column at each ;
Multi-Row Formula
=BYROW(A2:A6, LAMBDA(r, SPLIT(r, ";")))
Will SPLIT the strings in ...
- 2,975
0
votes
Is there away on google sheets to paste text and automaticly create new rows with every line break or etc?
This sounds like my question, but I admit to not understanding the answers given. I had selected and copied ctrl-c about 20 lines from a Google calendar invite - a list of procedure steps. I wanted ...
1
vote
How to shuffle a range but prevent refresh?
Assuming the range to shuffle is in A2:C, put this formula in cell H2:
=let(
refresh, H1,
freeze_, lambda(_, _),
randomNumbers_, lambda(r, c, randarray(r, c)),
freeze_(randomNumbers_(999, ...
- 12.7k
Top 50 recent answers are included