View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sei Sei is offline
external usenet poster
 
Posts: 4
Default Extract street number (foreign address)

Thank you, this works well.

"Teethless mama" wrote:

=LOOKUP(99^99,--MID(SUBSTITUTE(A1,"
",""),MIN(FIND({0,1,2,3,4,5,6,7,8,9},SUBSTITUTE(A1 ,"
","")&"0123456789")),ROW(INDIRECT("1:256"))))