LiamBogur

Google Spreadsheets randomize capitalization formula

Jul 19th, 2020
157
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. =ARRAYFORMULA(UNICHAR(CODE(SPLIT("T.E.S.T","."))+CHOOSE(ROUND(RANDARRAY(1,4))+1,0,32)))
  2.  
  3. To use just capitalize your word and replace T.E.S.T with your word, make sure to include a . between each letter. Also change the 4 in RANDARRAY to the length of your word. Do not put any symbols in there or lowercase letters, if you want to include lowercase letters use TEXTJOIN, like below:
  4.  
  5. =TEXTJOIN("",FALSE,ARRAYFORMULA(UNICHAR(CODE(SPLIT("T.H.I.S","."))+CHOOSE(ROUND(RANDARRAY(1,4))+1,0,32)))," ",ARRAYFORMULA(UNICHAR(CODE(SPLIT("I.S","."))+CHOOSE(ROUND(RANDARRAY(1,2))+1,0,32)))," ",ARRAYFORMULA(UNICHAR(CODE(SPLIT("A","."))+CHOOSE(ROUND(RANDARRAY(1,1))+1,0,32)))," ",ARRAYFORMULA(UNICHAR(CODE(SPLIT("T.E.S.T","."))+CHOOSE(ROUND(RANDARRAY(1,4))+1,0,32))),"!")
Add Comment
Please, Sign In to add comment