Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) |