Combine 2 columns?

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
 
J

J.E. McGimpsey

One way:

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

copy C1 down as far as necessary.
 
S

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.
 
Top