Microsoft Office Tutorials and References
In Depth Information
2
Date & Time
3
Math & Trig
4
Statistical
5
Lookup & Reference
6
Database
7
Text
8
Logical
9
Information
10
Commands
11
Customizing
12
Macro Control
13
DDE/External
14
User Defined
15
Engineering
16
Cube
17
Compatibility*
18
Web**
*The Compatibility category was introduced in Excel 2010.**The Web category was introduced in Excel 2013.
Adding argument descriptions
When you use the Insert Function dialog box to enter a function, the Function Arguments dialog box displays
after you click OK. For built-in functions, the Function Arguments dialog box displays a description for each of
the function's arguments.
In Chapter 26, I present a function named EXTRACTELEMENT:
Function EXTRACTELEMENT(Txt, n, Separator) As String
Returns the nth element of a text string, where the
elements are separated by a specified separator character
Dim AllElements As Variant
AllElements = Split(Txt, Separator)
Search JabSto ::




Custom Search