Most of the time I have a column with comments in my reports and it may happen that I need to know only some information after a specific word. In fact, I use this formula each time I need to display the most valuable data in order to discard the ones not important. It can be a comment, a number, a date, etc.
When I use the formula ?
To display comments after finding some particular letters.
How to use the formula ?
The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".
How are the formulas ?
=MID()
=FIND()
=LEN()
=INDEX()
=MATCH()
This formula shows a number of characters after finding the word:
=MID(A2,FIND("-",A2)+1,5)
Once this formula will find the score "-", it will display the 5 characters after it.
Explanation:
This formula shows all information after finding the word:
=MID(A2,FIND("something",A2)+10,LEN(A2))
Explanation:
This formula does the same thing as above, the only difference is that it is asking only to display comments for “chocolate”.
=MID(INDEX(A1:A10,(MATCH("chocolate",B1:B10,0))),FIND("-",INDEX(A1:A10,(MATCH("chocolate",B1:B10,0))))+1,5)
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...