I need to be able to do this: Take the value in C2 and tell me if that value is anywhere in cell E2. If it is in E2, perform a FIND with C2 value in only the E2 cell, and REPLACE with "" (blank). This is what I have so far. =IF(SEARCH(C57,E57,1) > 0,"Yes","no")
Can anyone help me out with this?
Last edited by Delkath; 09-07-2010 at 03:58 PM.
Maybe all you need is (in a new cell):
=SUBSTITUTE(E2,C2,"")
this will replace the string in C2 if it exists in E2 with a null... otherwise it leaves it alone.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Wow, much more simple then the route I was going and it worked perfect. Thanks NBVC!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks