Split text with length

[vivian2u]

yes, the user used to put delimiter between a house (or lot#) and the street name.

[MartinLiss]

Is my code anything like what you want?

[vivian2u]

Thank you. I need to try it out first. Heres are my coding, since i dont know how to fixed the length, i make it in other way. It might not in the good standard but it works. I will try yours too.

Dim strLineArr() As String
Dim strWordArr() As String
Dim intLineIdx As Integer, intWordIdx As Integer

strLineArr() = Split(txtAddress.Text, vbCrLf)

For intLineIdx = 0 To UBound(strLineArr)
strWordArr() = Split(strLineArr(intLineIdx), ",")
If Len(strWordArr(0)) < 5 Then
rs_add(1) = strWordArr(0) & "," & "" & strWordArr(1) & ","
For intWordIdx = 2 To UBound(strWordArr)
rs_add(intWordIdx) = strWordArr(intWordIdx) & ","
Next
Else
For intWordIdx = 0 To UBound(strWordArr)
rs_add(intWordIdx) = strWordArr(intWordIdx) & ","
Next
End If
Next

[szlamany]

yes, the user used to put delimiter between a house (or lot#) and the street name.

Since the comma is required between the house/lot# and street name then you cannot use SPLIT - that's obvious.

Do you always have a house/lot# in your data entry - or can there be a street name by itself?