VB Code to split the text String

Hello:

I have text string "Z1/Groups /12-22-2013/01:09" in cell A7.
I need a VB Code ( would need VB Code and not formula) to split the above as follows:

Cell F7 : "Z1/Groups"
Cell G7 : "12-22-2013"
Cell H7 : "01:09"

Please help and let me know if any questions.

Thank you.

Riz Momin

Hi Riz, what are the criteria for splitting the text? (e.g. what's the decision that makes "Z1/Groups" split to column F?)
Could you share more samples?
Is the length of date/time consistent across your data? (i.e. dd-mm-yyyy/hh:mm)

Hello:

The file will have text string in this format always : "Z1/Groups /dd-mm-yyyy/hh:mm"

Please let me know if any questions.

Riz Momin

Try:

Please Login or Register  to view this content.

Hello:

I am now using below code but it is erroring out.
Please help...I have attached sheet.

Please Login or Register  to view this content.

Hi Riz, both arr1 and arr2 are arrays.
If you prefer to declare them, try:

Please Login or Register  to view this content.