Counting Characters

  • Thread starter Thread starter mstover34
  • Start date Start date
M

mstover34

Is there any way to count the number of characters in an individua
cell? For example, if I have the word "revenue" in Cell A1, I woul
like Cell B1 to return 7 in cell B1
 
Hi
=LEN(A1)

if you want to exclude spaces use
=LEN(SUBSTITUTE(A1," ",""))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
CONDITIONAL FORMATTING QUERY 0
Return Range Based on Cell Value 2
Lookup function to cell containing multiple values 3
Constant date in one cell 1
Stop Rounding Currency 20
Excel Need Countifs Formula Help 0
automatic calculation 3

Back
Top