Forum Discussion
Solved
Formula to get information after searching for specific words in excel.
Hello Community! I am looking for a way to make Excel return the specific value after looking for words in a cell. For example: look for the "Course ID:" in cell D and if it is present display the n...
- something like this (you might need to tweak a little. I added some 'space' on each end and then added the trim but you might want to use +11 and ,6 assuming the course ID is 6 digits. If it isn't you may need another search for where to cut it off. That could be a a space or "Course Title".
=IFERROR(TRIM(MID(D2, SEARCH("Course ID:",D2)+10, 8)),"")
something like this (you might need to tweak a little. I added some 'space' on each end and then added the trim but you might want to use +11 and ,6 assuming the course ID is 6 digits. If it isn't you may need another search for where to cut it off. That could be a a space or "Course Title".
=IFERROR(TRIM(MID(D2, SEARCH("Course ID:",D2)+10, 8)),"")
=IFERROR(TRIM(MID(D2, SEARCH("Course ID:",D2)+10, 8)),"")