View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bobby Bobby is offline
external usenet poster
 
Posts: 75
Default seperate street name and number

I have street addresses in 1 column - I want to seperate into 2 columns the
first being the number and the second being the street name. I'm using the
function MID but I have to keep changing when amount of numbers difer. Must
be a better way.
Thanks