This example is made up of the date function TODAY() which returns the current date as a number (NOTE: is represented as 39814) and the text function TEXT() which allows you to format the numeric representation of the date in a textual format. 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. This function should therefore not be regarded. dialogue, in the box labelled Format Code. Example format codes are found in the Format - Cells. Syntax: TEXT(number format) returns number converted to text, according to the format code specified by format. Combines several text strings into one string.ĬONCATENATE(text1 text2. Converts a number into text according to a given format.
0 kommentar(er)
