In exel can we merge to fields into one? if yes how?

Answer 1

When you merge cells, you need to remember that only the contents of the first cell is retained. If you want to merge the contents of the cells, and not just the area, you need to write a formula, using the CONCATENATE option, or just link the cells using "&" character in you formula.

Answer 2

For MS-Excel [ STEPS ]:-

Select the cells to merge >> right Click on selected cells >> select Format Cells >> window will open, Select Alignment tab >> Check Merge Cell checkbox.

Answer 3

I'm not sure exactly what you mean, but if you mean making a several cells into one big one that spans multiple rows and/or columns, then you do that by highlighting all the cells you want to be together, then choosing the "Merge Cells" command.

Answer 4

Select The cells you want to merge click "Format" in menu and then click " cells"

In the "alignment tab" you will see text control check box.. in that check the box where it says merge cells... and its'done

Answer 5

Drag and select the two cells. Right click. Select "Format cells". Select the "Alignment tab" and click on "Merge cells."

Answer 6

yes,
highlight it, drag (the cells to merge)
right click look at the options it says there merge cells,
then click it.

Answer 7

mark the cells, right click, merge