WRITTEN BY: supportmymoto.com STAFF
A textual content worth (additionally known as a “textual content string”) is one among Excel’s main content material varieties. Different varieties of content material embrace numbers, dates, instances, and Boolean values.
As knowledge is entered right into a worksheet, Excel makes a “greatest guess” on the kind of content material it’s, and codecs the worth robotically. By default, textual content values are aligned on the left, and numeric values (together with dates and instances) are aligned on the best. This alignment shortly exhibits which values Excel considers textual content.
Textual content values in formulation
In a system, textual content values require particular remedy, and should be enclosed in double quotes (“”). For instance, the system beneath makes use of the IF operate to check a price in A1:
If A1 is larger than 70, the result’s “Move”. If the worth in A1 is much less or equal to 70, the result’s “Fail”. Discover each “Move” and “Fail” are surrounded with double quotes. This tells Excel to deal with these values as textual content. The double quotes is not going to be seen within the closing end result.
To check if a price is textual content, you need to use the ISTEXT operate. Within the system beneath, ISTEXT will return TRUE if A1 incorporates textual content and FALSE if not:
Programmers seek advice from textual content values as “textual content strings”. A particular type of textual content worth an “empty string”, which suggests a textual content worth with no textual content. Empty strings will seem as empty double quotes (“”). You will see empty strings seem in formulation like this:
Translation: if A1 is empty, return an empty string, in any other case return A1.
Empty strings do not show something in Excel. The system above, when A1 is empty, will return a end result that appears like an empty cell.
Enter quantity as textual content
To enter a quantity as textual content immediately in a worksheet (i.e. not in a system), precede the quantity with a single quote character (‘). The ensuing worth can be textual content, however it’ll nonetheless appear like a quantity. The only quote is not going to be seen.