A cell receives input that can be any combination of "PRICE", "NO BOL", or other word(s).
How do I search that cell for the other word(s) that is not "PRICE" or "NO BOL" and copy the other word(s) into a variable?
I feel like there is a very simple function call that I havent found yet.
Thanks.
-Luke
This UDF should do the trick:-
For Data in "A1" enter function as:- =nfil(A1)
To Save and Run UDF:-
Please Login or Register to view this content.
Copy Function from Thread
In Your Data sheet , Click "Alt+F11",:- Vb Window appears.
From the VBWindow toolbar, Click "Insert" ,"Module":- New VBwindow appears .
Paste Code into this window.
Close Vbwindow.
In sheet, Add the "function" in a cell as :- =nfil(A1)
NB:- Once you've added the first bracket you can select the range from the sheet
Then click "Enter"
The cell should now show the result.
Regards Mick
Last edited by MickG; 08-07-2019 at 12:53 PM.
I'm actually calling it from a userform, but it works great! I can adapt that to clean up a bunch of other code I have. Thanks!
You're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks