Thread: excel formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
katey mic katey mic is offline
external usenet poster
 
Posts: 1
Default excel formula

Hi, Can anyone help me? Im new to this. I'm using excel 2007. I have a street
number and name in one column. How can i get autocomplete to work with the
street names when the street numbers are different? Its a long database of
names and adresses and everytime i add one i have to type road, street, lane
and the street name when I know their already in the column?
Thanks in advance, katey