Index for alpha and exclude alpha from count

[#1]

How do I index for alpha letters and filter them from my count?

Tag#
520657A
520657B
230626
252067A
520657
252067
252376

[swuehl]

If you just need a count, you may use

=NumericCount([Tag#])

(or the complement: TextCount([Tag#])  )

Regards,

Stefan

[swuehl]

And if you need to do something else, you could use the boolean functions

isNum([Tag#]) resp. isText([Tag#]) to distinguish the Tags with the alphanumeric suffix from the pure numerical ones.

Hope this helps

[its_anandrjs]

Hi,

It is your column or the count, if it is a column so you need to put a code like =keepchar(Tag#,0123456789) to remove alpha by this you able to remove alpha from column if it is so.

Hope this helps you

Regards,

Anand