Example: Left(“Mr. Spock”, 5) Result = S” “Mr. the last characters of n)—returns n string Example: Right(“Vulcans Rule”, 4) Result = “Rule” Mid(string, a character of string, returns the n1, n2)—starting n1 first characters n2 Example: Mid(“Amok Time makes Vulcans crazy.”, 6, 18) Result = makes Vulcans” “Time Omitting returns the rest of the string: n2 Mid(“Amok Time makes Vulcans crazy.”, 6) Result = makes Vulcans crazy.” “Time Len(string)—returns the number of characters in string (spaces count) Example: Len(“Captain Picard rocks!”) Result = 21 Referencing Worksheets Can refer to the names” of worksheets “code (and chart sheets).
Example: Left(“Mr. Spock”, 5) Result = “Mr. S” n)—returns the last n characters of string Example: Right(“Vulcans Rule”, 4) Result = “Rule” Mid(string, n1, n2)—starting a character n1 of string, returns the first n2 characters Example: Mid(“Amok Time makes Vulcans crazy.”, 6, 18) Result = “Time makes Vulcans” Omitting n2 returns the rest of the string: Mid(“Amok Time makes Vulcans crazy.”, 6) Result = “Time makes Vulcans crazy.” Len(string)—returns the number of characters in string (spaces count) Example: Len(“Captain Picard rocks!”) Result = 21 Referencing Worksheets Can refer to the “code names” of worksheets (and chart sheets).