Or it can be 1 which means the SPLIT function will do a textual comparison.Either it is 0 which means SPLIT will perform a binary comparison which means every character should match itself.Compare is a compare method which is one of the two below: Compare: This final argument is also an optional argument.This concludes that the string will be broken apart each time there is a delimiter in the string. But again if we do not provide a limit to the function VBA treats it as default -1. Limit means the maximum number of parts we want to do of a string. Limit: This is also an optional argument.It is the specific delimiter that divides the string but by default, space is considered as default delimiter. Delimiter: This is an optional argument.It is basically the input string we provide. Expression As String: This is a mandatory argument in the SPLIT function.Example: We have a string as COMPUTER and we want to PUT as the substring then the code will be as follows:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |