microsoft excel training day courses near kent

microsoft excel training day courses near kent - Columns, text

Resolved · Low Priority · Version Standard

Columns, text

Lauren has attended:
Excel Advanced course

by - delegate Lauren [1 post] (2007 Oct 17 Wed, 15:21) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	1	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	5	book now	£219	£235
Full Schedule: See all 96 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Columns, text

by - trainer Amanda diamond contributer [1240 posts] (2007 Oct 17 Wed, 16:47) Reply

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