application development excel - Creating formulas

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

Resolved · Low Priority · Version Standard

Creating formulas

Dafni has attended:
Excel Advanced course
Access Advanced course
Word Advanced course

by - delegate Dafni [2 posts] (2007 Mar 9 Fri, 09:33) Reply

how to add strings

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

RE: creating formulas

by - trainer Richard platinum contributer [788 posts] (2007 Mar 12 Mon, 16:23) Reply

Dafni,

I am note 100% sure about your question, so I will assume you want to add strings together from 2 cells into one.

You can use the CONCATENATE function for text strings.

=CONCATENATE(E2,"-",F2)

Try it out for yourself, and see if it is what you are looking for.

Richard

· A Beginners Guide To Formulas In Excel
· Microsoft Excel Training Course
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Microsoft Excel Training: Essential for Today's Employees
· Tap the Power of Recorded Macros with MS Excel Courses

Excel tip:

Concatenating Results of Formulas

To concatenate the results of formulas simply add the "&" after the formula or function closing bracket.

function1(....)&function2(.....)

see example Creating a range of monthly payments as text.

View all Excel hints and tips