How to add cell 3(house #) to cell 4(Street name) in Db of 170,00.

R

raritan

I have a Db of 170,000 adresses. The house # is in cell 3, the street name is
in cell 4. How do I merge these two?
 
J

John Vinson

I have a Db of 170,000 adresses. The house # is in cell 3, the street name is
in cell 4. How do I merge these two?
Click to expand...

Is this an Access database, or an Excel "database"? It's quite
possible in either case, but you're posting in an Access newsgroup and
referring to "cells" with cell numbers, which sounds like Excel rather
than Access.

If it is in Access, and you have fields named [3] and [4] (unwisely
IMHO), you can create a Query with a calculated field:

Address: [3] & " " & [4]

John W. Vinson[MVP]
 
Top