Loop Through a Range of Cells
One must-have VBA skill is the ability to loop (or enumerate) through a range of cells. If you do any serious macro...
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...
TEXT Function
Description TEXT function converts a numeric value to text and lets you specify the display formatting by using special format strings. This...
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...
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...
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...
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...
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....