Hi friends, I hope You will help me again, this time I have a new question:
If a cell contains a text, is it possible to count particular parts, for example in a cell I have a text:
17:00+1 – 10:00+1
I need to count all "+1" parts, so in this case in another cell the result should be 2 (because there are two "+1")
Hi there. try this.
Formula:
Please Login or Register to view this content.
The number at the end (2) should be adjusted to be equal to the length of the string that tyou're looking for (i.e. +1 = 2 characters).
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks, it works.
On second thoughts: use this. I certainly wouldn't automatically remember to adjust the 2 at the end...
Formula:Please Login or Register to view this content.
BtW, this will work for text, numbers and any combination, and (as set up) is case insesnsitive (so "a" is the same as "A")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks