vba-excel-training - merging columns

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

vba-excel-training - Merging columns

resolvedResolved · Low Priority · Version Standard

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?

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

RE: Merging columns

Thanks Paul

That is going to save me hours!

Lorna

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


Server loaded in 0.08 secs.