Is it possible to count the no. of characters in a cell in Excel?
in [Functions]
|
Prev: Bond premium amortization using the constant yield method
Next: Inserting a blank row between rows of data
From: karbrown12 on 26 Jan 2010 15:19 In order to create Tweets in Excel, I wanted to know if you could count the characters/spaces in a cell.
From: Mike H on 26 Jan 2010 15:24 Hi, To count characters excluding spaces =LEN(SUBSTITUTE(A1," ","")) to count spaces =LEN(A1)-LEN(SUBSTITUTE(A1," ","")) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "karbrown12" wrote: > In order to create Tweets in Excel, I wanted to know if you could count the > characters/spaces in a cell.
From: Teethless mama on 26 Jan 2010 15:24
=LEN(A1) "karbrown12" wrote: > In order to create Tweets in Excel, I wanted to know if you could count the > characters/spaces in a cell. |