Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do you create a string literal in excel?

Tags:

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?

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?

like image 442
David542 Avatar asked Apr 26 '16 01:04

David542


People also ask

How do you make a string literal?

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.

How do you create a string in Excel?

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.

What is an example of a string literal?

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."'

Is there a string function in Excel?

Excel String Functions – SummaryExcel string functions can be used to retrieve specific characters within a string.


1 Answers

Put a simple quote before the minus sign, like: '-eodllH

like image 52
Marcel Kohls Avatar answered Sep 18 '22 12:09

Marcel Kohls