Is is possible to achieve the below with any formula?
A1=Mangobanana
B1=Mango
C1 (with Formula) = banana
Is is possible to achieve the below with any formula?
A1=Mangobanana
B1=Mango
C1 (with Formula) = banana
Hi,
This is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.
Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.
We need to understand whether A1 always starts with the B1 characters. I suspect it's not as simple as that.
If it does then a simple
=SUBSTITUTE(A1,B1,"")
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Thank you Richard, this is exactly what I was looking for. Have a good day & stay safe!
Hi Richard,
Another question, I noticed in my worksheet that some of the B1 cells are blank but I know what data needs to be there. Is there any formula where I can get the same result but instead of comparing it with B1, it will be compared with a range of cells where I can manually enter my dynamic data. I have created a sample workbook as attached. Thanks for all your help.
This is a new question, so start a new thread with a suitable title, please.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Its a same question. just clarifying new condition.
Try:
=SUBSTITUTE(A2,LOOKUP(2,1/ISNUMBER(SEARCH($B$2:$B$17,A2)),$B$2:$B$17),"")
Quang PT
Thank you so much. Have a good day!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks