PurposeThe OCFilter function is useful to work around the maximum forumla length limit of Excel by allowing you to break a single formula into smaller pieces. The OCFilter function was originally created to address Office Connector formulas with complex filter arguments, but it can be used for any text argument in any Excel formula.
SyntaxOCFilter( filter template , enclosers , arg1 , [ ... argn ] ) The OCFilter function syntax has these parts:
|filter template||Required. This argument specifies a pattern containing literal text and replacement markers.|
|enclosers||Required. This argument specifies how your filter template will identify replacement markers.|
|arg 1 ... arg n||Optional. This is a comma-delimited list of values used to replace the markers in the filter template. Quite often you will use cell references to columns on the current row that contain key values for your filter. If no arguments are specified, then the filter template is returned unchanged.|