Functions

From Wiki for The Only Sheet
Revision as of 22:07, 11 July 2012 by Admin (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
Retrieved from "https://theonlysheet.com:443/wiki/index.php?title=Functions&oldid=2821"