excel courses - What is Concatenate and how does it work?

The UK's most regular instructor-led training courses.
Training information: excel courses · Excel courses london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

What is Concatenate and how does it work?

Sean has attended:
No courses

by - delegate Sean [1 post] (2007 Jun 28 Thu, 14:08) Reply

What is Concatenate and how does it work?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003	2008 Sep 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Sep 4 Thu	Bayswater	4	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
Full Schedule: See all 138 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: What is Concatenate and how does it work?

by - trainer Amanda platinum contributer [947 posts] (2007 Jun 29 Fri, 14:29) Reply

Hi Sean

Thank you for your question.

The Concatenate function is designed to join text strings together, for example, if you had a person's first name in say cell A1 and their last name in cell B1, you could put the Concatenate function into cell C1 to join the first and last name together =concatenate(a1,b1). If you want a space between the words, use =CONCATENATE(A1," ",B1).

I hope this helps.
Amanda

· Advanced level training: Microsoft Excel and the Web
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Fun Things I've Done With Excel
· How to Create Better Excel Spreadsheets: Part Three
· How Excel Training Can Improve Your Company's Sales Process