Split text with length

[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?