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 ...
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, ...
Top 50 recent answers are included
Related Tags
google-sheets-arrayformula × 810google-sheets × 794
formulas × 486
google-sheets-query × 269
vlookup × 100
google-sheets-dates × 64
regex × 62
concatenate × 44
google-sheets-arrays × 32
regexextract × 28
google-apps-script × 26
importrange × 26
filter × 19
conditional-formatting × 17
google-forms × 15
google-sheets-charts × 11
sorting × 10
google-sheets-timestamp × 10
google-sheets-custom-function × 9
google-sheets-filter × 9
google × 8
google-finance × 8
links × 6
microsoft-excel × 6
text-formatting × 5