Combine 2 columns?

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I am trying to combine the contents of 2 columns (Street
number and street name) and can't figure out how to do
it. None of my Microsoft Office 2000 "help" files will
work. Any help is appreciated. Jim
 
One way:

A1: <street number>
B1: <street name>
C1: =A1 & " " & B1

copy C1 down as far as necessary.
 
Hi Jim

This is simple. assume u want to add cell A1 and B1, just
type =A1&" "&B1 in another cell (say C1). The result
would be the addition of contents of two columns. drag
down the formula for adding the contents of respective
cells.
 
Back
Top