Creating Named Ranges Creating a named range via VBA is much less involved. You can directly define the Name property of the Range object: Sheets(“Sheet3”).Range(“A1:D10”).Name = “MyData” Selecting Named Ranges You simply pass the name of the range through the Range object. This allows you to select the range: Range(“MyData”).Select…
Description TEXT function converts a numeric value to text and lets you specify the display formatting by using special format strings. This function is useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols. Syntax TEXT(value,…
Description T function returns the text referred to by value. Syntax T(value) Parameters value Required. The value you want to test. Remarks If value is or refers to text, T returns value. If value does not refer to text, T returns “” (empty text). You do not generally need to…
Description VALUE function converts a text string that represents a number to a number. Syntax VALUE(text) Parameters Text Required. The text enclosed in quotation marks or a reference to a cell containing the text you want to convert. Remarks Text can be in any of the constant number, date, or…
Description RIGHT returns the last character or characters in a text string, based on the number of characters you specify. RIGHTB returns the last character or characters in a text string, based on the number of bytes you specify. What is the difference between RIGHT and RIGHTB? RIGHT is intended…
Description SUBSTITUTE function substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string. Syntax SUBSTITUTE(text, old_text, new_text, [instance_num]) Parameters Text…
Description REPLACE function replaces part of a text string, based on the number of characters you specify, with a different text string. REPLACEB function replaces part of a text string, based on the number of bytes you specify, with a different text string. Use REPLACE when you want to replace…
Description PROPER Function capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters. If you want to converts all uppercase letters in a text string to lowercase, please use LOWER function. If you want…