View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fableman Fableman is offline
external usenet poster
 
Posts: 1
Default how to make a function to extract from to

Sesam street 4B
Motherstreet 56
Jungle terror street 5
Monky do funky street 6D

How can I make a function that extract the street number ex. 4B, 56, 5 and
6D ?

and

How to make a funtion that only extract the street named and not the numbers ?

(English not my native language , hope you understand what I try to ask for)


//Thanks..