answersLogoWhite

0

Use the LEN function. It will count the amount of characters in a cell or in a literal piece of text.

To count the amount of text in cell A3, put this formula into another cell:

=Len(A3)

The following will give you 11 as there are eleven characters, including the space in the piece of text:

=LEN("Hello World")

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What company logo has blue letters with a word that ends in xel?

Excel :P


What is column break in Microsoft Excel?

A column break is a term associated with Microsoft Word, not Excel. In Word, it starts a new column of text. In Excel, you can just go to another column to start entering new data.


What two letters name a word meaning to surpass others?

XL - excel


In word Excel 2007 what are the last three letters of the columns?

XFD is the column label on the last column in a Microsoft Excel 2007 worksheet.


What is a 40 letter word in the English language?

There is no 40-letter word the longest English word ishippopotomonstrosesquippedaliophobia (36 letters)Pneumonoultramicroscopicsilico volcanoconiosis (45 letters) (no Break)Had to put a break in, otherwise the full word would not show.


How do you break down the word ophthalmoscope?

ophth almo scope that is you break the word ophthalmoscope


what is a holiday with 5 letters?

Labor Day (when the word 'day' is not counted)


How can you change lower case letters into capital letters?

There is no way in Excel to do that without writing a special macro. The options for changing case in Excel are:LOWER - Converts all uppercase letters in a text string to lowercase.UPPER - Converts all lowercase letters in a text string to uppercase.PROPER - Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.


When children sound out a word to try and figure out what it is this is an example of?

Phonics, which is the method of teaching children how to read by correlating sounds with individual letters or groups of letters in a systematic way. Sound out a word helps children break it down into phonemes and blend them together to figure out the word.


What is word processing in excel?

Excel is not a word processor. There are lots of things in it that a word processor has, like a spell checker, text formatting, alignment and other things. If you really wanted to, you could use it to type a letter, but that is not what it is for. It is not ideal for doing it. It would be more awkward to write a letter in it than it would be to use an actual word processor. So you would use a word processor to type letters and do spreadsheets in Excel.


What a another word for fall or break down?

collapse.


How do you break down the word quesadilla?

Ques-a-dill-a