This example serves to demonstrate that you can combine functions in quite complex ways. Here Calc converts each number given by ROUND(RAND()*10)) to text before concatenating.ĬONCATENATE("Print Date: " TEXT(TODAY() "dddd, d mmmm yyyy")) returns Print Date: Thursday, 1 January 2009 (assuming today's date was Jan 1, 2009). 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.
0 Comments
Leave a Reply. |