Forum Discussion

Copper Contributor

Mar 24, 2023

Question on excel formula and functions for individual cell attributes

Hello, Can anyone help me with this excel question. Is there an excel formula that I can use that would help me count a specific attribute within an individual cell? For example: a_b ...

excel

Formulas and Functions

OliverScheurich

Gold Contributor

Mar 24, 2023

Cammy2250

=LEN(A1)-LEN(SUBSTITUTE(A1,"_",""))

You can try this formula.

Cammy2250

Copper Contributor

Mar 27, 2023

OliverScheurich

Thank you. It looks like this worked. I had no idea there is a formula called LEN. I'm pretty basic in formula so I learned something new today!

THANK YOU!!