Hello all
I am trying to use an array function in a Macro Enabled Excel, which was
working perfectly on a Normal Excel file, but is not working now.
Can you anyone explain why is this happening?
IFERROR(SUBSTITUTE(TEXTJOIN("",TRUE,IF(CODE(MID(V6,ROW(INDIRECT("$1:$"&LEN(V6))),1))=63,MID(V6,ROW(INDIRECT("$1:$"&LEN(V6))),1),"")),"?",""),"")
Thank you
Bookmarks