ExcelHowTo
Tutorials
Getting Started with Excel
Formulas and Functions
Charts and Graphs
Tips & Tricks
Troubleshooting
How To
Data Analysis
Programming with VBA
Functions
Excel Functions
Compatibility functions
Cube Functions
Database Functions
Date and Time Functions
Engineering Functions
Financial Functions
Information Functions
Logical Functions
Lookup and Reference Functions
Math and Trigonometry Functions
Statistical Functions
Text Functions
User Defined Functions
Web Functions
Books
Macros
Shortcuts
VBA
Creating, Selecting and Formatting Named Ranges Via VBA
Creating Named Ranges Creating a named range via VBA is much less involved. You can directly define the Name property of the...
6 years ago
0
Text Functions
TEXT Function
Description TEXT function converts a numeric value to text and lets you specify the display formatting by using special format strings. This...
6 years ago
0
Text Functions
T Function
Description T function returns the text referred to by value. Syntax T(value) Parameters value Required. The value you want to test. Remarks...
6 years ago
0
Text Functions
VALUE Function
Description VALUE function converts a text string that represents a number to a number. Syntax VALUE(text) Parameters Text Required. The text enclosed...
6 years ago
0
Text Functions
RIGHT, RIGHTB Function
Description RIGHT returns the last character or characters in a text string, based on the number of characters you specify. RIGHTB returns...
6 years ago
0
Text Functions
SUBSTITUTE Function
Description SUBSTITUTE function substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a...
6 years ago
0
Text Functions
REPLACE, REPLACEB Function
Description REPLACE function replaces part of a text string, based on the number of characters you specify, with a different text string....
6 years ago
0
Text Functions
PROPER Function
Description PROPER Function capitalizes the first letter in a text string and any other letters in text that follow any character other than...
6 years ago
0
Page navigation
Page 4 of 16
«
First
‹
Previous
Page
2
Page
3
Current Page
4
Page
5
Page
6
Next
›
Last
»