Forum Discussion
Cammy2250
Mar 24, 2023Copper Contributor
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
a_b_c
a_b_c_d_e
I would like to know if there is a fomula that would help to identify and count the number of underscores in each cell. the first example would be a count of 1 underscore. Followed by 2 underscores and so on.
Can anyone provide any guidance or advice? I really don't want to have to manually count it.
Thank you so much.
Camille
4 Replies
- Patrick2788Silver Contributor
- Cammy2250Copper Contributor
- OliverScheurichGold Contributor
- Cammy2250Copper ContributorOliverScheurich
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!!