Return text up to the second space in Microsoft Excel Find if a character is in a cell in Microsoft Excel Find if a character is in a range in Microsoft Excel Find the most commonly repeated string in a column in Microsoft Excel Parsing text to the right of a search criteria - delimiter in Microsoft Excel Count the number of times in particular date a text appear in adjacent column in Microsoft Excel Using Cell Reference with Keyboard signs in the Criteria Range argument when using COUNTIF formula. Make LEFT Function recognize a number Calculating the Average of Every Nth Value, Excluding Zeros Removing Redundant Characters from a Range of Cells and Resetting the Format Avoiding Problems when Numeric Values are used as Text Counting number of unique entries in a specified range. Splitting a Full Address into Three Separate Cells Creating New IP Addresses Counting the Number of Excel Files in a List According to File Type and Date Criteria Altering results returned in case of an error. Retrieve Value Using Case-Sensitive Lookups Creating email address Separating a Number Into Digits Separtaing A String Into Substrings. Restricting Cell Entries to Text Only Restricting the Number of Characters Entered into a Cell Preventing Duplicates When Entering Data Combining Text and Formatted Numbers into a Single Entity Combining Text and a Formatted Date into a Single Entity Combining Numbers that Have Leading Zeros Combining the Contents of Every N Number of Cells into One Value Encoding a Sequence of Letters Combining Text and Numerically Calculated Results into One Output String Formulas Erroneously Appearing as Text Adjusting a Formula to Return a Blank, Rather than a Zero, When Operating on Empty Cells Checking Whether Cells in a Range are Blank, and Counting the Blank Cells Removing Hidden Apostrophes from Imported Numbers Subdividing a Mixed String into Separate Cells Containing only Numbers or Characters Extracting the First N Number of Words from a String Converting Numbers with Trailing Minus Signs to Normal Negative Numbers Replacing Substrings with Numbers from Adjacent Cells Performing Numeric Operations on Substrings Searching a String for a Matching Word from another String Find the Alphabetically Lowest Letter in a List Identifying Numeric Values within a Range Formatted as Text Identifying the Case of Letters within Strings Finding the Relative Position of Numbers within a String Searching a String for a Specific Substring Determining Long Distance Phone Calls, Based on the Number Dialed Rearranging a String in Alphabetic Order Reversing the Word Order within a String Retrieving the Cell Address of the Largest Value in a Range Retrieving Each Row Number that Corresponds with Successful Matches in a Look Up Retrieving the Row Number that Corresponds with a Matched Value in a Look Up
Copyright © 2003 ExcelTip.com
Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation
Site Developed By: Irubin Consulting