[RESOLVED] separation field

hi,

I in one field I have: "name surname"
What I would like is to separate it to 2 fields so I have in one field "name" and in another "surname".


Adnan,

Not quite sure what you mean but try this quick sample and hopefully it'll work for you:

Code:

---

Dim strText$
Dim arValues() As String

    strText = "name surname"
    arValues = Split(strText, Space(1))
    Debug.Print arValues(0) 'name
    Debug.Print arValues(1) 'surname

---

thank you,

That is what I needed

Great!