Learn To Join Two Columns In Excel Instantly.

Asked By Liezl Gomez 0 points N/A Posted on - 04/21/2017

I am a beginner in MS Excel. I know the basic formulas used in Excel, but to join two columns in excel, I totally am worthless.

By mistake, I have used two columns for an address while I had to use only one in one of the Excel sheets.

Is there any way to combine those columns now?

• Status: Open
• Question Views: 414
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel
• Question Tags: columns | MS excel

Answered By Ljupcho Rano 0 points N/A #295065

Learn To Join Two Columns In Excel Instantly.

You have to follow these steps to do that:

1. First of all, click on the cell where you wish to put the combined text.
2. In that cell, type =(
3. Next, click the cell which contains the first text that you want to add, i.e. the address column 1 in this case.
4. After that, type &” “&(along with a space enclosed within quotation marks).
5. Next, Click the cell which contains the text that you wish to combine, i.e. address line 2.
6. Finally, type )and press ENTER.

About Ljupcho Rano

Questions
3

Answers
7

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 04/21/2017
• Question Category: MS Excel