LinkBack URL
About LinkBacks
For xl2010 you will need to test each cell individually likeFormula:
=MID(IF((ISNUMBER(SEARCH($B$2,A2))),","&$B$2,"")&IF((ISNUMBER(SEARCH($B$3,A2))),","&$B$3,"")&IF((ISNUMBER(SEARCH($B$4,A2))),","&$B$4,""),2,1000)
For xl2010 you will need to test each cell individually likeFormula:=MID(IF((ISNUMBER(SEARCH($B$2,A2))),","&$B$2,"")&IF((ISNUMBER(SEARCH($B$3,A2))),","&$B$3,"")&IF((ISNUMBER(SEARCH($B$4,A2))),","&$B$4,""),2,1000)
You are right 2010 is a bit outdated for this. I tried the first formula provided by @dosydos In excel at live.com and it worked. This is a great help for me it's going to save me a huge lot of time, I will be using this very frequently. Thanks a lot, guys! I love this forum. 珞
Last edited by AliGW; 09-02-2022 at 08:30 AM. Reason: Please DON'T quote unnecessarily!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks