test suite

text

37 tests · 14 with documented divergences

Test	Subject	Formula	Category	DVs
`621ba3`	CONCAT	`=CONCAT("hello", " world")`	value	1
`04872d`	CONCATENATE	`=CONCATENATE(A1, A2, A3, "!")`	value
`2cae7b`	CONCAT	`=CONCAT("value:", 42)`	value	1
`fdfc2d`	LEFT	`=LEFT("Sale Price", 4)`	value
`fd913f`	LEFT	`=LEFT("Sweden")`	value
`b2a4d1`	RIGHT	`=RIGHT("Sale Price", 5)`	value
`6d9936`	RIGHT	`=RIGHT("Stock Number")`	value
`19f600`	MID	`=MID("Romain", 3, 4)`	value
`32205c`	MID	`=MID("Romain", 1, 2)`	value
`064ba7`	MID	`=MID("Romain", 3, 6)`	value
`3cea0e`	MID	`=MID("Romain", 0, 3)`	value	2
`8e3073`	MID	`=MID("Romain", 1, -1)`	value
`ad919d`	LEN	`=LEN("Phoenix, AZ")`	value
`ed3e09`	LEN	`=LEN("")`	value
`f7c2dc`	LEN	`=LEN(" One")`	value
`a78e07`	LOWER	`=LOWER("E. E. Cummings")`	value
`aaa336`	UPPER	`=UPPER("total")`	value
`7c7b17`	UPPER	`=UPPER("Yield")`	value
`7af21f`	TRIM	`=TRIM(" First Quarter Earnings ")`	value	1
`c14911`	SUBSTITUTE	`=SUBSTITUTE("hello world", "world", "earth")`	value
`d8f921`	SUBSTITUTE	`=SUBSTITUTE("abcabc", "a", "x")`	value
`5b568f`	SUBSTITUTE	`=SUBSTITUTE("abcabc", "a", "x", 2)`	value
`d74c30`	FIND	`=FIND("M", "Miriam McGovern")`	value
`2bdded`	FIND	`=FIND("m", "Miriam McGovern")`	value
`81d83e`	FIND	`=FIND("M", "Miriam McGovern", 3)`	value
`cd2ec2`	FIND	`=FIND("B", "Miriam McGovern")`	value
`4ccc5c`	EXACT	`=EXACT("word", "word")`	value	1
`d71904`	EXACT	`=EXACT("Word", "word")`	value	1
`d0ff05`	REPLACE	`=REPLACE("abcdefghijk", 6, 5, "*")`	value	1
`9f0644`	REPLACE	`=REPLACE("2009", 3, 2, "10")`	value	1
`b0c6a1`	REPT	`=REPT("ha", 3)`	value	1
`6c29cb`	REPT	`=REPT("ha", 0)`	value
`20455f`	TEXTJOIN	`=TEXTJOIN(", ", TRUE, A1:A3)`	value	1
`5038f9`	TEXTBEFORE	`=TEXTBEFORE("Brian Wiles", " ")`	value	1
`c9fb28`	TEXTBEFORE	`=TEXTBEFORE("one,two,three", ",", 2)`	value	1
`598724`	TEXTAFTER	`=TEXTAFTER("Brian Wiles", " ")`	value	1
`be6810`	TEXTAFTER	`=TEXTAFTER("one,two,three", ",", 2)`	value	1