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...
0

TEXT Function

Description TEXT function converts a numeric value to text and lets you specify the display formatting by using special format strings. This...
0

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...
0

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...
0

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...
0

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...
0

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....
0

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...
0