New answers tagged

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 ...
Blind Spots's user avatar
  • 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 ...
BrentHarsh's user avatar
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, ...
doubleunary's user avatar
  • 12.7k

Top 50 recent answers are included