Search Results for "Text"
233 results were found in the following tip categories:
Excel Keyboard Shortcuts
- Quickly Entering Text into Cells from a List of Previous Entries or a Validation List
- Combining Text from Different Cells
- Adding a Linked Picture to a Chart in Microsoft Excel
Excel Text
- Selecting cells that only contain Text in Microsoft Excel
- Finding/Finding & Replacing in a Single Sheet or in All Sheets
- Extracting Characters from Text Using Text Formulas
- Convert text to lower case in Microsoft Excel
- Counting how many times specific character appears in cell in Microsoft Excel
- Extract the first word in a cell in Microsoft Excel
- Extract the last word in a cell in Microsoft Excel
- Extract all the words except the first in Microsoft Excel
- Count the number of words in a cell in Microsoft Excel
- Using the Validation Input Message as a Cell Comment
- Applying Formatting Only to Cells Containing Text
Excel General
Excel Importing Text Files
- Problem: The Minus Sign Appears to the Right of the Number
- Problem: Date Formatting Cannot Be Changed
- Problem: Values Not Formatting as Numbers
- Create and Add a Function for Reversed Text Characters in Microsoft Excel
- Importing a Text File in Excel 2007
- Unnecessary Blank Characters in Cells in Excel 2007
- The Minus Sign Appears to the Right of the Number in Excel 2007
- Playing sound notes using VBA in Microsoft Excel
- Convert negative values treated as text using VBA in Microsoft Excel
- Private Profile Strings using INI-files using VBA in Microsoft Excel
- Private Profile Strings using Words System.PrivateProfileString using VBA in Microsoft Excel
- Display all installed fonts (Word) using VBA in Microsoft Excel
- Converting Text to Its Proper Case
- Return text up to the second space in Microsoft Excel
- Converting Text to Uppercase
- Convert text to lower case in Microsoft Excel
- Return the cell reference as text in Microsoft Excel
- Create a hyperlink from a string in Microsoft Excel
- Copying Formulas from a Range of Cells Without Changing the Absolute or Relative References
- The Power Combination
- Validating Text Entries
- Validating text entries in Microsoft Excel
- Copying and Pasting Validation list only in Microsoft Excel
- Automatically Wrapping Text in a Cell
- Manually Wrapping Text in a Cell
- Preventing Text from Spilling Over
- Adding a Shortcut for Wrapping Text
- Changing the Indentation in a Cell
- Dividing a First Left Heading Title
- Changing a Numeric Heading to Text
- Combining Text and Formatted Values
- Combining Text and a Formatted Date
- Extracting Characters from Text Without Using Formulas
- Separating First and Last Names Using Formulas
- Separating First and Last Names Without Using Formulas
- Searching for text in Microsoft Excel
- Linking a Cell to a Text Box
- Quickly Entering a Long Company or Person Name
- Validating Text Entries in Excel 2007
- Filling a Range with a Series of Dates in Excel 2007
- Quickly Entering Text into Cells from a List of Previous Entries or a Validation List in Excel 2007
- Quickly Entering a Web Site address Email Address or Company Name in Excel 2007
- Finding/Finding & Replacing in a Single Sheet or in Entire Workbook in Excel 2007
- Protecting Cells Containing Text or Formulas Only, in a Protected Sheet in Excel 2007
- Limiting the Movement in an Unprotected Sheet in Excel 2007
- Proofing in Excel 2007
- Changing the Name of the Cell Comments Author in Excel 2007
- Printing Cell Comments in Excel 2007
- Using the Validation Input Message as a Cell Comment in Excel 2007
Files, Workbook, and Worksheets in VBA
- Use messageboxes using VBA in Microsoft Excel
- Log files using VBA in Microsoft Excel
- Read information from a closed workbook using VBA in Microsoft Excel
- Log files using VBA in Microsoft Excel
- Format number in joining text with linked number in Microsoft Excel
- Rounding Numbers to Thousands
- Rounding Numbers to Millions
- Rounding Numbers to Thousands with Hundreds as a Decimal
- Rounding Numbers to Millions with Thousands as a Decimal
- Formatting a Negative Number with Parentheses
- Replacing Zeros with Dashes in Number Formatting
- Creating and Saving Custom Styles
- Coloring Rows Based on Text Criteria
- Symbols Used to Create Custom Formatting
- Merging and Centering in Excel 2007
- Changing the Indentation in a Cell(s) in Excel 2007
- Automatically Wrapping Text in a Cell in Excel 2007
- Manually Wrapping Text in a Cell in Excel 2007
- Preventing Text from Extending Beyond the Range in Excel 2007
- Dividing a First Left Heading Title in Excel 2007
- Changing a Numeric Heading to Text in Excel 2007
- Applying Formatting to Cells Containing Text Only in Excel 2007
- Customizing Date Formatting in Excel 2007
- Color Unique Record in a Range in Excel 2007
- Values Not Formatted as Numbers in Excel 2007
Links between Worksheet and Workbooks
Excel Sorting
Summing
- Summing Using Text Characters as Criteria
- Summarize data according to criteria from the data table using Sumif formula, Offset formula and Combo Box in Microsoft Excel
- Preventing a Vlookup Function From Returning an Error When an Exact Match Is Not Found
- Creating Formulas that Only Return Results from Non-Blank Cells
- Finding the Largest Number among Those Meeting Specified Criteria
- Extracting a substring
- Reversing Strings
- Correcting Formatting Errors
- Extracting last Word
- Preventing a VLOOKUP Function from Returning an Error when an Exact Match is Not Found
- Avoiding the Occurrence of Unexpected VLOOKUP #N/A Errors
- Checking If Matching Numbers Exist in Different Ranges
- Calculating the Lowest Common Multiple (LCM)
- Calculating Net Sale Price According to Text Criteria
- Simplifying Formulas by Defining Names for Often-Repeated Parts
- Copying Formulas from a Range of Cells without Changing the Absolute or Relative References in Excel 2007
- Selecting Cells That Contain Errors in Formulas in Excel 2007
- Range Name Syntax in Excel 2007
- Defining a Range Name in Excel 2007
- Use Name in a Formula in Excel 2007
Excel Tools
Cells, Ranges, Rows, and Columns in VBA
Excel Style
- Automating the Insertion of the Euro Symbol
- Use AutoCorrect to enter special symbols in Microsoft Excel
- Counting the Number of Cells Containing Text in a Range
- Counting how many times specific character appears in cell in Microsoft Excel
Menus, Toolbars, Status bar in VBA
Excel Array Formulas
- Counting Based on Multiple Criteria
- Find the maximum numerical value in a list based on a criteria in Microsoft Excel
- Find the minimum numerical value in a list based on a criteria in Microsoft Excel
- Change the value/content of several UserForm-controls using VBA in Microsoft Excel
- Decide what an INPUTBOX is supposed to return using VBA in Microsoft Excel
- Create User Forms in Microsoft Excel
- Create a hyperlink from a string in Microsoft Excel
- Grouping/ Ungrouping Sheets
- Grouping/Ungrouping Sheets in Excel 2007
- Changing the Default Auto-Save File Location in Excel 2007
Excel Formula
- Extract the first word in a cell in Microsoft Excel
- Extract the last word in a cell in Microsoft Excel
- Extract all the words except the first in Microsoft Excel
- Count the number of words in a cell in Microsoft Excel
Excel Summing
Excel Counting
- Coloring Numbers Based on Specific Criteria Using Conditional Formatting
- Using the COUNT Functions
- Counting the Number of Cells Containing Text
- Counting the Number of Cells Containing Text
Custom Functions
- Create and Add a Function for Reversed Text Characters in Microsoft Excel
- Writing Your First VBA Function in Excel
Excel Pivot Tables
- Adding a Calculated Percentage Field
- Rules for Organizing the Source Data in Excel Sheets
- PivotTable Report Terminology
- PivotTable report - Grouping Text Fields
- Automatic Report formatting using option buttons
- Creating PivotTable in Excel 2007
- Grouping Text Fields in Excel 2007
- Inserting a Calculated Field in Excel 2007
- Retrieving a Value from a PivotTable Report in Excel 2007
Excel Security - Protection
- Protecting the Sheet or the Cells in the Sheet
- Protecting Sheets / Cells in Microsoft Excel
- Limiting the Movement in an Unprotected Sheet
- Change text in header when printing using VBA in Microsoft Excel
- Conditional formatting depending on a cell comment using VBA in Microsoft Excel
- Printing page number in the opposite direction in landscape layout page in Microsoft Excel
- Inserting a Watermark Behind the Text
- Printing a Page Number in Portrait While the Page Is in Landscape Layout
- Hiding Data Before Printing
- Inserting a Watermark behind the Text in Excel 2007
- Printing a Page Number in Portrait While the Page Is in Landscape Layout in Excel 2007
- Hiding Cells before Printing in Excel 2007
- Calculating Total Time Worked on a Specific Day
- Converting a Month's Serial Number into Its Corresponding Name
- Adding Text Values Representing Time
- Converting Text Representing Minutes and Seconds into Numerical Values
- Calculating Military Time Intervals
- Converting Text, Which Represents Date and Time, Into Proper Date and Time Values
- Creating a Date and Time Matrix
- Calculating Total Time Worked on a
- Combine the Index and Match formulas in Microsoft Excel
- Index Formula vs. Vlookup Formula
- Using VLOOKUP and ISNA functions to find matching values in different sheets
- Avoiding the Occurrence of Unexpected VLOOKUP #N/A Errors
- Retrieving Values from another Sheet Using Date as Sheet Name Reference
- Retrieving Values from another Excel Workbook Using Text References
- Finding the Maximal / Minimal String, Based on Alphabetic Order
- Create and Add a Function for Reversed Text Characters in Microsoft Excel
- Import data from a text file (ADO) using VBA in Microsoft Excel
- Replace text in a text file using VBA in Microsoft Excel
- Return text up to the second space in Microsoft Excel
- Find if a character is in a cell 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
- Make LEFT Function recognize a number
- Removing Redundant Characters from a Range of Cells and Resetting the Format
- Avoiding Problems when Numeric Values are used as Text
- Creating email address
- Restricting Cell Entries to Text Only
- 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 Text and Numerically Calculated Results into One Output String
- Formulas Erroneously Appearing as Text
- Removing Hidden Apostrophes from Imported Numbers
- Identifying Numeric Values within a Range Formatted as Text
- Distribute Data from a List of the day to day sheets using VBA
- Replace text in a text file using VBA in Microsoft Excel
Information Formulas
- How to eliminate N/A error result when using Vlookup formula in Microsoft Excel
- How to change error result calculation when using Vlookup formula to 0 or empty cell in Microsoft Excel
- Control Outlook from Excel using VBA in Microsoft Excel
- Control Word from Excel using VBA in Microsoft Excel
Modules, Class Modules in VBA
- Add a procedure to a module using VBA in Microsoft Excel
- Add content to a module from a file using VBA in Microsoft Excel
- Insert a new module from a file using VBA in Microsoft Excel
- Class modules using VBA in Microsoft Excel
- Find the maximum numerical value in a list based on a criteria in Microsoft Excel
- Find the minimum numerical value in a list based on a criteria in Microsoft Excel
- Find duplicates items in combine columns in Microsoft Excel
- Find the value in the first non blank cell in range in Microsoft Excel
- Find the last numeric value in a range in Microsoft Excel
