Hi, I need to find the cell that has a text string (a number actually), that is at the beginning of the rest of some other text. To illustrate, in column C I have cells that contain this:
965 Los Angeles Dodgers C Kershaw - L
966 Colorado Rockies J Chacin - R
.
.
.
I need to do a search on all the cells in column C looking for the cell that contains the number, say, 966. I can't really use MATCH or LOOKUP because they would be looking for a cell that has 966 in it by itself - in other words they look for a perfect match. I need something that will detect my search string (966) *anywhere* within the cells to be searched. And if this function could return the exact cell location where it's found, that would be perfect!
Thanks!
Shawn
Bookmarks