[RESOLVED] separation field

[greenba]

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,

[RhinoBull]

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

Dim strText$
Dim arValues() As String

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

[greenba]

thank you,

That is what I needed

[RhinoBull]

Great!