Lets Split!

Posted on Thursday 22 December 2005

Came across the VB Split fucntion which I had never used before today, fom help: (anoted)

Description

Returns a zero-based, one-dimensional array containing a specified number of substrings.
Syntax
Split(expression[, delimiter[, limit[, compare]]])
Expression, Required. ‘’the string
Delimiter, Optional. ‘’String character used to identify substring limits. If omitted, the space character (” “) is assumed to be the delimiter.
Limit, Optional. ‘’Number of substrings to be returned; –1 indicates that all substrings are returned.
Compare, Optional. ‘’Numeric value indicating the kind of comparison to use when evaluating substrings. See Settings section for values.
might be handy to have this around!


No comments have been added to this post yet.

Leave a comment

(required)

(required)


.

Use [VBA] Your Code [/VBA], when posting code, cheers Ross x /


RSS feed for comments on this post | TrackBack URI