Is there a way to look for text in cells using the Find function.
The additional criteria is that it has to be the first word only.
In the example shown, the first word to find is "This". The result should be Rows 1 to 2, instead of Rows 1 to 7.
I would think it could de done using an array but want to avoid if looping through large amounts of data.
Capture2.PNG
Please Login or Register to view this content.
Bookmarks