keepvur.blogg.se

REPT(ROUND(RAND()*10) 3) returns nnn where n is a random digit repeated three times. "al" & "tog" & "ether" also returns altogether.ĬONCATENATE(A1 A2) where cell A1 contains key and cell A2 contains board returns keyboard.ĬONCATENATE(ROUND(RAND()*10) ROUND(RAND()*10) ROUND(RAND()*10)) returns the text string xyz where x, y, z are three randomly independent digits, while: The ampersand operator & may also be used to concatenate text in a formula, without the function.ĬONCATENATE("al" "tog" "ether") returns altogether. Text1 - text30 may also be single cell references. text30) returns up to 30 text strings text1 - text30, joined together. Combines several text strings into one string.ĬONCATENATE(text1 text2.