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 numbers after the text found, in this case, 123456
Really appreciate the help!
- 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)),"")
2 Replies
- 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)),"")
