Thread
:
Extract street number (foreign address)
View Single Post
#
7
Posted to microsoft.public.excel.worksheet.functions
Sei
external usenet poster
Posts: 4
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"))))
Reply With Quote
Sei
View Public Profile
Find all posts by Sei