How Do You Create a String Literal in Excel?
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?...
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?
1 Answer
Put a simple quote before the minus sign, like: '-eodllH
Marcus Vance is a cybersecurity auditor and technology writer dedicated to educating the public about online safety, data privacy regulations, enterprise security, and emerging cyber threats.
