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)


--
foff
------------------------------------------------------------------------
foff's Profile: http://www.excelforum.com/member.php...o&userid=26272
View this thread: http://www.excelforum.com/showthread...hreadid=395640