Home
Tips & Tutorials
Functions Examples
VBA Examples
Excel
Search
Edit and Format
Editing
Formatting
Cell Formatting
Data
Data Entry
Data Validation
Pivot Tables
Charts and Graphics
Chart Types
Graphics
General
Formulas and Functions
Date and Time
Text Formulas
Math Functions
LookUp Formulas
User Defined Functions
General
Workbook and Worksheets
General
Customizing
Printing
Workbook and Worksheets
VBA and Macros
Basics
Cells and Ranges
Workbook and Worksheets
Files and Folders
Printing
UserForms and InputBoxes
General
Excel Formulas and Functions : Text Formulas
Displaying
1-20
of
22
1. Efficient Excel Spreadsheet Design
2. How to Change the Case of Text
3. Cleaning Text
4. Filtering and Extracting a Record That Contains a Text String
5. Using the REPT Function
6. Specifying Proper Case
7. Convert Text to Upper/Proper Case
8. How to Return the Nth Word from a String
9. Extracting Words From Text in Excel
10. Using the CONCATENATE Worksheet Function
11. Creating proper names format with =PROPER()
12. Returning the Left-most Characters
13. Working with time formats with =TEXT
14. Count Text or Numeric Entries with COUNTA instead of COUNT
15. Convert Text to Proper Case
16. Concatenating Names with Delimiters
17. Changing 'All Caps' to proper text with =PROPER()
18. Converting Codes to Characters
19. Changing #N/A to "Your Response" text with =IF()
20. Automatically add a character in a cell
1
2
Next
Total Pages:2
Excel Add-ins
Find duplicates , remove characters , change case , merge cell's text.
Visually display and store in a library cell's formatting.
PowerPoint Add-ins
Easily save and apply the formatting of a shape.
Create a library from your custom animations.
Pick colors from screen for your shapes.
Home
Contact Us
PowerPoint, Excel, Word and Access are registered trademarks of the Microsoft Corporation.
