Hi all,
I have the below formula which extracts the first 2 words of a filename, and it's been great for years, however, all of a sudden today it no longer works, can anyone advise or help?
=LEFT(TRIM(MID(@CELL("filename",A2),SEARCH("[",@CELL("filename",A2))+1,SEARCH(".",@CELL("filename",A2))-1-SEARCH("[",@CELL("filename",A2)))),FIND("^",SUBSTITUTE(TRIM(MID(@CELL("filename",A2),SEARCH("[",@CELL("filename",A2))+1,SEARCH(".",@CELL("filename",A2))-1-SEARCH("[",@CELL("filename",A2))))&" "," ","^",2))-1)
Thank you in advance
MM
I have the below formula which extracts the first 2 words of a filename, and it's been great for years, however, all of a sudden today it no longer works, can anyone advise or help?
=LEFT(TRIM(MID(@CELL("filename",A2),SEARCH("[",@CELL("filename",A2))+1,SEARCH(".",@CELL("filename",A2))-1-SEARCH("[",@CELL("filename",A2)))),FIND("^",SUBSTITUTE(TRIM(MID(@CELL("filename",A2),SEARCH("[",@CELL("filename",A2))+1,SEARCH(".",@CELL("filename",A2))-1-SEARCH("[",@CELL("filename",A2))))&" "," ","^",2))-1)
Thank you in advance
MM