AK_Excel_13
New Member
- Joined
- Jul 11, 2014
- Messages
- 30
I am trying to do something, but I am not sure if excel can do it.
In column C:C, I have a list of over 100,000 hyperlinks. These hyperlinks are very long and have a lot characters in them. These hyperlinks sometimes contains a project number.
In range F2:F100, I have a list of project numbers.
In column D:D, I would to see which hyperlinks (in column C:C) contain a project number (range F2:F100) somewhere in the text.
Can excel do this?
Thank you!
In column C:C, I have a list of over 100,000 hyperlinks. These hyperlinks are very long and have a lot characters in them. These hyperlinks sometimes contains a project number.
In range F2:F100, I have a list of project numbers.
In column D:D, I would to see which hyperlinks (in column C:C) contain a project number (range F2:F100) somewhere in the text.
Can excel do this?
Thank you!