[RESOLVED] Split question

Let's say there is data with one delimiter vbCrlf :

Code:

---

Jack
Jhon
James
George

---

it's easy to split this data using code like this:

Code:

---

entry= Split(data, , vbCrLf, vbBinaryCompare)

---

But, how i can I split the data that has two delimiters: vbCrlf & Space? Something like this:

Code:

---

010203 Jack
909090 Jhon
304050 James
506070 George

---

This example contans "space" and "new line", how can I split them?

Thanks

Code:

---

Entry = Split(Replace(Data, vbCrLf, " "))

---

If you know the format of those first 6 characters, you can use mid() function in conjunction with split.
Or, you can use the instr() funtion to get everthing before the space. You can also use that to get the vbcr.
Lots of ways to parse this file.

Thanks guys! I thought it was a special function to split in this way without mid and instr :) Much appreciated!