Combine 2 columns?

[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

 

[Bob Phillips]

Jim,

In column C, input

=A1 & " " & B1

 

[J.E. McGimpsey]

One way:

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

copy C1 down as far as necessary.

 

[sandeep]

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.