How can I delimit with characters using vba?

Question

Example: consider there are 5 names separated with a semicolon. I want to separate these 5 names. consider, Richard;Pareek;Elizabeth;Creig;Tomy

Answer 1

You would use the Split() function.

Example:

Dim input as String
Dim results() as String

input = "Richard;Pareek;Elizabeth;Creig;Tomy"
results = Split(input,";")

Note: If there are are spaces after the semicolons, be sure to include that in the second parameter of the Split function (so "; " instead of ";")