BASIC IT INFO FOR DUMMY

Asked By anonymous 7060 points N/A Posted on - 04/07/2012

What command or commands can I use in MS EXCEL that will enable me to link two cells in one?

• Status: Open
• Question Views: 999
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Sherin Viluel

Go To Solution

Answered By hOmAm 0 points N/A #83186

BASIC IT INFO FOR DUMMY

Suppose there are two cells that you want to link. First cell contains 'First Name' and second cell contains the 'Last Name'.
Now you want to link 'First Name' and 'Last Name' and make new cell 'Name' that contains both 'First Name' and 'Last Name'

Suppose the 'First Name' is Sharon (in cell A2) and 'Last Name' is Joy (in cell B2).
Then type in cell C2 =A2&B2
Press enter.
The name will appear like this: SharonJoy.
If you want space between then change the C2 to this:
=A2&" "&B2

You can link to many cells like this. Link each cells with & sign and if you want spaces between them then use " ". You can add any thing other than space, whatever you add, it should be in double quotes.
For eg. If you want add comma instead of space the formula would be:
=A2&","&B2

About hOmAm

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/07/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Sherin Viluel 0 points N/A #83187

BASIC IT INFO FOR DUMMY

 

Data which are in two or more than two can be taken in to a one column in Microsoft excel easily.

According to your question I will take an example in order to explain how to complete your required task.

In the below image you can see Names are in column A and codes are in column B.

 

 

 

Now type the following formula in the cell C3.

=A3&B3

 

 

 

Now copy that formula in to below cells. It will display the name and the code in the same column.

 

 

 

However, if you want to put a dash (-) between the name and the code, you can type following formula and copy it down.

=A3&"-"&B3

 

 

 

About Sherin Viluel

Questions
0

Answers
50

Best Answers
37

• Vote Up 0 Vote Down

• Posted on - 06/28/2012
• Question Category: MS Excel