Thread: Extracting House Numbers from Street Addresses
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Extracting House Numbers from Street Addresses
All your examples have a number followed by a blank followed by the rest of
the address:

=LEFT(A1,FIND(" ",A1)-1)

--
Gary''s Student - gsnu200812
Reply With QuoteReply With Quote