Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training day courses near kent - Columns, text

microsoft excel training day courses near kent - Columns, text

ResolvedVersion Standard

Wed 17 Oct 2007, 15:21 Delegate Lauren said...

Lauren has attended:
Excel Advanced course

Columns, text

How do you put two columns of text together in one column?

Wed 17 Oct 2007, 16:47 Trainer Amanda said...

RE: Columns, text

Hi Lauren

Thank you for your question.

You should be able to use the CONCATENATE function to do this. For examle if column A contains first names and column B contains last names, you can display the full name in column C by entering the following:

=concatenate(A1," ",B1)

This will combine what's in cell A1 with what's in cell B1 with a space to separate them.

Amanda

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Showing all menu items

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items.
To turn this off so that you always get everything, go to Tools / Customize / Options Tab / "Always show full menus". Make sure there is a tick in the box and you will always have every item.

View all Excel hints and tips

microsoft excel training day courses near kent - Columns, text

Columns, text

RE: Columns, text

Excel articles

Excel tip:

Showing all menu items