vba-excel-training - Merging columns

Resolved · Low Priority · Version Standard

Tue 13 Nov 2007, 12:59 Delegate Lorna said...

Lorna has attended:
Excel Advanced course

Merging columns

Is it possible to merge two columns so that the data in both merges into one? For example one column has first names and the other has surnames, can they be merged so each cell contains both the first and surname?

Tue 13 Nov 2007, 14:41 Delegate Paul said...

RE: Merging columns

Hi Lorna

It's best to use concatenate for this.

let's say your data is in columns A & B

in cell C1, type =concatenate(A1, ,B1)

This will pull the names together. Notice that I've put a space in between the two columns in the brackets. This will put a space between the first name and surname for you..

Hope this helps

Paul

Tue 13 Nov 2007, 14:48 Delegate Lorna said...

RE: Merging columns

Thanks Paul

That is going to save me hours!

Lorna

Tue 13 Nov 2007, 14:51 Delegate Paul said...

RE: Merging columns

Anytime mate

Excel tip:

Change Excel's default font

You can change the default font and font size for all spreadsheets created in Excel by:

1. Going to Tools on the menu bar.
2. Select Options, then General.
3. Next to Standard Font you can change the font and font size.
4. Click OK.

Each new file you start from this point onward should use the font and font size you have selected.

View all Excel hints and tips

vba-excel-training - Merging columns

Merging columns

RE: Merging columns

RE: Merging columns

RE: Merging columns

Excel articles

Excel tip:

Change Excel's default font