F
foff
I have a field which is lets say 13 ABC Street
Now I'm trying to isolate the street name from the street number. I
tried this:
=mid(A1,SEARCH(" ",A1,1,len(a1)-search(" ",a1,1)
But it doesen't let me. What this does is searches for the first space
and returns a value of 3, so this tells the =mid to start from the third
character. Then I do a LEN to get the total number of characters then
SUBTRACTED by another search which should give me:
=mid(a1,3,10)
Now I'm trying to isolate the street name from the street number. I
tried this:
=mid(A1,SEARCH(" ",A1,1,len(a1)-search(" ",a1,1)
But it doesen't let me. What this does is searches for the first space
and returns a value of 3, so this tells the =mid to start from the third
character. Then I do a LEN to get the total number of characters then
SUBTRACTED by another search which should give me:
=mid(a1,3,10)