Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » vba-excel-training - Merging columns

vba-excel-training - Merging columns

ResolvedVersion 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:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips