combining two columns

R

Ryan

I have done this before, but can't seem to remember...how
do you combine two columns with text based info. I would
like to take a "house number" from one column and combine
it with the "street name" in another column.
Thanks. Ryan
 
G

Guest

many thanks Frank.

Also, how would i make that data permanent in the new
column so I can delete the other two columns? thanks in
advance. ryan
 
J

Jenny

Hi Ryan
Select the data that you want to keep. Choose Copy, then
Paste Special, and choose the Values option.

Jenny
Auckland, New Zealand
 
G

Gord Dibben

Copy the column and Paste Special(in place)>Values>OK>Esc

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to combine two columns into a new column 2
How do I combine the contents of two columns? 4
Vlookup formula combining two columns 2
combining column content 8
How do I combine two EXCEL columns? 4
combining columns on the worksheet 1
How to combine two columns? 1
Combining text from multiple cells 6

Top