paste two columns into one

  • Thread starter Thread starter Catsby
  • Start date Start date
C

Catsby

Hi,

I am dealing with a spread sheet in excel and I want to
paste two cells into one. I will be doing this for 315
rows, so I would like an easy function to do this. The
value for the first cell is an street address number (i.e.
123) and the second cell is a street name (i.e. Fake
Street). I want them to be displayed in a third cell that
says "123 FAKE STREET".. if the formula could also add the
space between the street number and street name, that
would be great!!!

Thx,
Catsby McFatters
 
Assuming your data is in columns A & B, then in Column C (or an empty
column), enter =A1&" "&B1 and fill down. Then copy this column & USe
Edit/Paste Special, select Values, then paste. Then you can delete columns A
& B.
Bob Umlas
Excel MVP
 
Back
Top