I have the following which needs to go into excel:
MovieID
-eodII2h
However, when I type it in, excel tries marking this up as a formula, and gives me:
#NAME?
Is there a way that I can skip the normal excel formatting on a cell, or if not, how to do a string literal in a cell?
A "string literal" is a sequence of characters from the source character set enclosed in double quotation marks (" "). String literals are used to represent a sequence of characters which, taken together, form a null-terminated string. You must always prefix wide-string literals with the letter L.
The easiest way to add a text string to a cell is to use an ampersand character (&), which is the concatenation operator in Excel. This works in all versions of Excel 2007 - Excel 365.
A string literal is a sequence of zero or more characters enclosed within single quotation marks. The following are examples of string literals: 'Hello, world!' 'He said, "Take it or leave it."'
Excel String Functions – SummaryExcel string functions can be used to retrieve specific characters within a string.
Put a simple quote before the minus sign, like: '-eodllH
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With