Formula/Function for Counting Characters in a cell
 

I'm trying to find a formula/function that count all characters in a cell.

Our employee's street address may exceed the maximum 25 characters allowed
and I need to know how many characters are in each street address cell so we
can edit it, if needed. Characters include numbers, text, spaces and
different characters such as # sign, commas, etc.
--
Thanks,
Cynthia

Formula/Function for Counting Characters in a cell
 

Hi
Try this function =Len(cell #)
HTH
John
"CyndiR" wrote in message
...
I'm trying to find a formula/function that count all characters in a cell.

Our employee's street address may exceed the maximum 25 characters allowed
and I need to know how many characters are in each street address cell so we
can edit it, if needed. Characters include numbers, text, spaces and
different characters such as # sign, commas, etc.
--
Thanks,
Cynthia

Formula/Function for Counting Characters in a cell
 

Thank you so much. It worked!!
--
Thanks,
Cynthia


"CyndiR" wrote:

I'm trying to find a formula/function that count all characters in a cell.

Our employee's street address may exceed the maximum 25 characters allowed
and I need to know how many characters are in each street address cell so we
can edit it, if needed. Characters include numbers, text, spaces and
different characters such as # sign, commas, etc.
--
Thanks,
Cynthia

Formula/Function for Counting Characters in a cell
 

You're welcome
John
"CyndiR" wrote in message
...
Thank you so much. It worked!!
--
Thanks,
Cynthia


"CyndiR" wrote:

I'm trying to find a formula/function that count all characters in a cell.

Our employee's street address may exceed the maximum 25 characters allowed
and I need to know how many characters are in each street address cell so we
can edit it, if needed. Characters include numbers, text, spaces and
different characters such as # sign, commas, etc.
--
Thanks,
Cynthia

Formula/Function for Counting Characters in a cell
 

=LEN(cellref)


Gord Dibben MS Excel MVP

On Mon, 16 Mar 2009 13:44:09 -0700, CyndiR
wrote:

I'm trying to find a formula/function that count all characters in a cell.

Our employee's street address may exceed the maximum 25 characters allowed
and I need to know how many characters are in each street address cell so we
can edit it, if needed. Characters include numbers, text, spaces and
different characters such as # sign, commas, etc.