software

if my culomn looks like that and i want to know how many ? and * i have the
culomn how do i make it happen? sometimes i have 2 symbols in the same cell.
thank you so much
*

?
*
*?
?

?*
*
?
*
The easiest way to calculate the number of characters in the column
would be to use an adjacent cell to calculate the length of the string
in each cell of your column, and then sum the results, as follows

A _____ B

* _____ =LEN(A2) {result would be 1}
*? _____ =LEN(A3) {result would be 2}=SUM(B1:B100)--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: www.excelforum.com/member.php...oamp;userid=32763
View this thread: www.excelforum.com/showthread...hreadid=525945Try something like this:

For a list of values in A1:A110
and a character to find in B1

C1:
=SUMPRODUCT(LEN(A1:A10)-LEN(SUBSTITUTE(UPPER(A1:A10),UPPER(B1),quot;quot;)))/LEN(B1)

If B1: ?
C1 will return the count of question marks in A1:A10 (even if there is more
than one in a cell)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;andrequot; wrote:

gt; if my culomn looks like that and i want to know how many ? and * i have the
gt; culomn how do i make it happen? sometimes i have 2 symbols in the same cell.
gt; thank you so much
gt; *
gt;
gt; ?
gt; *
gt; *?
gt; ?
gt;
gt; ?
gt;
gt;
gt; *
gt; *
gt; ?
gt; *
gt;

=SUMPRODUCT(--(LEN(A1:A10)))

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;andrequot; gt; wrote in message
...
gt; if my culomn looks like that and i want to know how many ? and * i have
gt; the
gt; culomn how do i make it happen? sometimes i have 2 symbols in the same
gt; cell.
gt; thank you so much
gt; *
gt;
gt; ?
gt; *
gt; *?
gt; ?
gt;
gt; ?
gt;
gt;
gt; *
gt; *
gt; ?
gt; *
gt;