Good day,
I have a list of applications, and need to check for CC and CS versions. If the title has a CC or CS, I want to extract that into column B. For example, if the application is After Effects CC 2015, I want CC 2015 to populate in column B. I am unsure of how to combine the two formulas to return the correct text, and if the CC or CS is not part of the title, to leave the cell blank. Any suggestions? (Yes, I know that is a goofy question here!)
You were pretty much there, just needed to handle the errors...
=IFERROR(MID(A2,FIND("CC",A2),7),"")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I had tried to combine the two MID-FIND formulas so the function could be performed within one formula. Is it possible to nest MID-FIND's?
Yes, you can, but with the sample you gave, why would you want to?
Does my suggestion give you what you wanted?
If I place the formula in cell B2 and populate it down the column, it does pick up all the CC entries; however, it leaves the CS entries blank. When I try =IFERROR(MID(A11,FIND("CC",A11),7),MID(A11,FIND("CS",A11),3,""), it errors out.
Maybe this..
Formula:
Please Login or Register to view this content.
Here is a shorter version
Formula:Please Login or Register to view this content.
Last edited by AlKey; 03-09-2017 at 05:34 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you! That is exactly what I needed! Perhaps someday, I will have an opportunity to understand it!
Last edited by reedersketer; 03-09-2017 at 04:12 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks