microsoft-excel-courses - Excel

The UK's most regular instructor-led training courses.
Training information: microsoft-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

Excel

Sohail has attended:
Excel Intermediate course
Excel Introduction course

by - delegate Sohail [1 post] (2007 Feb 26 Mon, 11:41) Reply

I wish first letter in "Excel" or in "Words" to be in Capital. How can I set this up?

Thank you,

Sohail

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 26 Mon, 14:37) Edited on 2007 Feb 26 Mon, 16:35 Reply

You can use a function called =PROPER() this function converts text to capitalise the first letter. WIthin the brackets you must select the cell that contain the text.

=PROPER(text)

This formula that returns text, or a reference to a cell containing the text you want to partially capitalize.

Hope that helps

Tracy

· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Microsoft Excel Training Advanced Courses - Making Data Validation Work For You
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips