Topic: Text Functions

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Checking for Text Need to figure out if a particular cell contains text? You can use the ISTEXT function to easily return this bit of trivia. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Cleaning Text You can use the CLEAN worksheet function to remove any non-printable characters from a cell. This can come in handy when you want to pare down what is stored in a worksheet. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Concatenating Names with Delimiters Combining information from various cells is an easy task in Excel. If you want to conditionally include information based on what is in the various cells, the proposition becomes trickier. This tip explains how you can conditionally combine information from cells to create a desired result. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Converting Codes to Characters Character codes are the numeric values used, by a computer, to signify various alphanumeric characters. You can use the CHAR worksheet function to discover the character code of any character. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Ignoring Case in a Comparison Do you want Excel to take the case of your text into account when it does comparisons in a formula? The IF statement ignores case, but here’s a technique to get it to pay attention. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Modifying Proper Capitalization The PROPER worksheet function is used to change the case of text so that the first letter of each word is capitalized. If there are some words you don’t want to have an initial cap, then you’ll want to use the ideas presented in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Reordering Last Name and First Name Names listed in a worksheet are often entered last name first. This tip provides a formula that can “turn around” such names so that the last name appears last. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Repeating Cell Contents Do you want to repeat the contents of a cell throughout the entire width of a cell? There are two ways you can do it in Excel—one method formulaic and the other through formatting. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Returning an ANSI Value Programmers know that you often need to look at the character code used for a specific character. Excel allows you to determine the same value through the use of the CODE worksheet function. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Returning the Left-most Characters Need only the left=most characters from a text string? You can use the LEFT worksheet function to easily get just what you need. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Specifying Proper Case The PROPER worksheet function, described in this tip, allows you to change the case of text in a cell. Creative use of the function can get your text into just the condition that you desire. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Using the CONCATENATE Worksheet Function Want to join snippets of text together in a cell? You can do this using the CONCATENATE worksheet function, as described in this tip. You can also use the ampersand operator, which is a shorthand method of using the worksheet function. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Using the REPT Function The REPT worksheet function is helpful for repeating a character or series of characters through the whole width of a cell. This tip explains how to use this rather esoteric function. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Tips, Tricks, and Answers

Perplexed by Pivots?

Helpful Links

Great Info!

RSS Feeds