Functions

From Wiki for The Only Sheet
Revision as of 23:10, 25 July 2012 by JeffK88 (talk | contribs)
Jump to navigation Jump to search

ExtractElement(str,n,sep)

Returns the nth element from a string, using a specified separator character

  • Parameter: str as String, n as Integer, sep as String
  • Example: =ExtractElement("Monkey&Apes&Chimps",2,"&")
  • Returns: Apes

Ordinal(n)

Given an integer, returns a string with that number, and the ordinal of that number.

  • Parameter: n as Integer
  • Example: =Ordinal(3)
  • Returns: 3rd


ConcatenateStrings (range,column,filter,filter column,separator)

Takes a range of values, and concatenates them together with a separator

  • Parameters:
Retrieved from "https://theonlysheet.com:443/wiki/index.php?title=Functions&oldid=2824"