 |
Training Index
Functions by category Text Functions
in Microsoft Excel
|
|
|
Excel formula and functions that help with manipulating
text in excel cells.
Below are some video clips of extremely useful
text functions built into
Microsoft Excel.
Be aware that these video clips use Windows Media Player.
|
Click on the hyperlink and, depending on your connection speed,
you may need to wait a few moments.
| Title |
Price
|
Video
Clip
|
|
FIND
The FIND function allows
you to search for a particular character within some text which is
especially useful when trying to extract parts of the text.
Excel Help File
Description: FIND finds one text string (find_text) within another
text string (within_text), and returns the number of the starting
position of find_text, from the first character of within_text. You
can also use SEARCH to find one text string within another, but unlike
SEARCH, FIND is case sensitive and doesn't allow wildcard characters.
|
|
FIND |
 |
|
LEN
The LEN function tells you
how many characters make up a cell which is particularly useful when
trying the manipulate the text within the cell.
Excel Help
File Description: LEN returns the number of characters in a text
string.
|
|
LEN |
|
Concatenate and &
The Concatenate (or &) can be used to join up the contents of
multiple cells into one cell. This text function is extremely useful for generating unique
keywords or preparing intelligent reports.Excel Help File Description:
Joins several text strings into one text string
|
FREE |
|
|
Lower, Upper, Proper
These text functions give you the ability to change the capitalization
(case) of cells to being all lower, or all UPPER, or Proper.Excel Help File Description:
Lower and Upper converts all uppercase (lowercase) letters in a text
string to lowercase (uppercase). Proper capitalizes the first letter
in a text string and any other letters in text that follow any
character other than a letter. Converts all other letters to lowercase
letters
|
FREE |
|
|
Left, Right, Mid
These text functions give you the ability to to extract certain segments of
a cell (normally text). Useful if only part of a cell's text contains
the information you want..Excel Help File Description: LEFT
(RIGHT) returns the first (last) character or characters in a text
string, based on the number of characters you specify. MID returns a
specific number of characters from a text string, starting at the
position you specify, based on the number of characters you specify
|
FREE |
|
|
|
Quote of the page:
I never think of the future. It comes soon enough.- Albert Einstein
(inventor)
|
|
|
Trying to stop spreadsheet errors in your
organization?
Learn about the benefits of
Spreadsheet Professional! |
Do you like what you see. Tell your friends. If you have a training co-ordinator
at your organisation tell them that there is free excel training available
at this site.
Don't like what you see. Tell us at
training@AuditExcel.co.za .
Do you have suggestions of what you would like to see. Tell us at
training@AuditExcel.co.za .
|
