Remember Me?

#1
December 6th 04, 06:20 PM
 Joe Posts: n/a
count in cell

Does anybody know how I can count the number of characters in a cell, I know

how to use the 'count' and 'counta' function to count the number of cells

used but not in a cell.

Thanks

#2
December 6th 04, 06:24 PM
 Frank Kabel Posts: n/a

Hi
=LEN(A1)

--
Regards
Frank Kabel
Frankfurt, Germany

Joe wrote:
Does anybody know how I can count the number of characters in a cell,
I know

how to use the 'count' and 'counta' function to count the number of
cells

used but not in a cell.

Thanks

#3
December 7th 04, 03:33 AM
 Dave Peterson Posts: n/a

And if you want to count the number of times "X" or "x" shows up in a cell:

=len(a1)-len(substitute(upper(a1),"X",""))

Joe wrote:

Does anybody know how I can count the number of characters in a cell, I know

how to use the 'count' and 'counta' function to count the number of cells

used but not in a cell.

Thanks

--

Dave Peterson

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Markus Obermayer Excel Discussion (Misc queries) 1 January 4th 05 09:01 PM Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM lsundae Excel Worksheet Functions 4 November 18th 04 03:11 PM Louisa Excel Worksheet Functions 0 November 5th 04 12:58 PM eagerbuyer Excel Worksheet Functions 1 November 4th 04 01:27 PM

All times are GMT +1. The time now is 03:42 AM.