Leading the way in Microsoft Office Development

Excel

Basic

 -

Getting Started

 -

Entering Text

 -

Numbers as Text

 -

Concatenating Text

 -

Formatting Text

 -

Comparing Text

 -

Wrapping Text

 -

Useful Formulas

 -

Inserting Symbols

 -

Text To Columns Wizard

 -

Import Text File

Worksheet Functions

 -

CHAR - Returns the character with the corresponding ANSI number.

 -

CLEAN - Returns the text string with all the non-printable characters removed.

 -

CODE - Returns the ANSI number for the first character in a text string.

 -

CONCATENATE - Returns the text string that is a concatenation of several strings.

 -

DOLLAR - Returns the text string of a number with the dollar formatting $0,000.00.

 -

EXACT - Returns the boolean value based on whether two strings match exactly.

 -

FIND - Returns the position of a substring within a larger text string.

 -

FIXED - Returns the text string of a number rounded to a fixed number of decimal places.

 -

LEFT - Returns the first or left most character (or characters) in a text string.

 -

LEN - Returns the number of characters in a text string.

 -

LOWER - Returns the text string with all the characters converted to lower case.

 -

MID - Returns the text string which is a substring of a given string.

 -

PROPER - Returns the text string with the first letter of every word as a capital letter.

 -

REPLACE - Returns the text string with a number of characters replaced.

 -

REPT - Returns the text string with a smaller text string repeated a number of times.

 -

RIGHT - Returns the last or right most character (or characters) in a text string.

 -

SEARCH - Returns the position of a substring within a larger text string.

 -

SUBSTITUTE - Returns the text string with a substring substituted for another substring.

 -

T - Returns the text string of the value given.

 -

TEXT - Returns the text string of a number in a particular format.

 -

TRIM - Returns the text string with all spaces removed from the beginning and end.

 -

UPPER - Returns the text string with all the characters converted to upper case.

 -

VALUE - Returns the number that a text string represents.

Advanced

 -

Languages

 -

ASCII String Codes

 -

Advanced Techniques

 -

Office Online

 -

Knowledge Base

Shortcut Keys

(Alt + Enter) - Enters a carriage return in a cell.

(Alt + 0162) - Enters the Cent ¢ character.

(Alt + 0163) - Enters the Pound £ character.

(Alt + 0165) - Enters the Yen ¥ character.

(Alt + 0128) - Enters the Euro € character.

Related Topics

 -

AutoCorrect

 -

Functions