Excel Text Formulas Tips - All Tips (50 tips)
- 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
»Click here to submit a tip to Excel Text Formulas tips
