Posts Tagged ‘combining’

You have a spreadsheet and the first and last name are in their own cells but you would prefer them to be in a cell together but you don’t want to retype them all again.  Here is a simple solution:

Assuming you are using Column A and Column B:

Insert an empty column after column B (Highlight the next column>Click Insert>Column

Highlight the first cell in the empty column

At the top of the screen there is an area that is a formula bar

In the formula bar type the following: =A1&” “&B1

Click Enter

There you have it, the names are now combined.

To do this to the entire spreadsheet:

Highlight the cell of the combined names

Hold Shift>down arrow key

Highlight as far as you would like to go

Click>Edit>Fill>Down

There you have it, the whole spreadsheet now has the names combined.

Bookmarks

Tweet This Post