To Create a String
1. In a worksheet, click where you want to create a string.
2. Press the double-quote key, ". A pair of double quotes appears.
3. Type any combination of letters, numbers, or other characters in the placeholder.
4. Click outside the expression or press Enter.
Additional Information
Editing strings differs from editing other math expressions. Entering Spacebar is interpreted as just another character in a string.
The position of the first character in a string is zero. For example, in the string "yes" the letter "y" is the 0th character. To associate string indexing with the array ORIGIN, on the Calculation tab, in the Worksheet Settings group, click Calculation Options and select ORIGIN in Strings. String indexing is important in interpreting the behavior of string functions.
Was this helpful?