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

excel formula
 

Katey

I would enter numbers in one column and street names etc. in other columns.

You can always join them together afterwards.

=A1 & " " & B1 to get 123 Street

Most databases keep segments of that type of data in separate columns for
ease of manipulation later.

i.e. Name Address City State ZIP in 5 columns

Autocomplete will then operate as you want.


Gord Dibben MS Excel MVP

On Sat, 4 Oct 2008 15:50:01 -0700, katey mic <katey mic
@discussions.microsoft.com wrote:

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

excel formula
 

"Gord Dibben" wrote:

Katey

I would enter numbers in one column and street names etc. in other columns.

You can always join them together afterwards.

=A1 & " " & B1 to get 123 Street

Most databases keep segments of that type of data in separate columns for
ease of manipulation later.

i.e. Name Address City State ZIP in 5 columns

Autocomplete will then operate as you want.


Gord Dibben MS Excel MVP

On Sat, 4 Oct 2008 15:50:01 -0700, katey mic <katey mic
@discussions.microsoft.com wrote:

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

Gord, thank you for your help. sincerely katie mic