I am doing a simple find() formula in excel, returning true if the string is found.
If you could please look at the attachment:
I need a way to format cell B1 so that the formula works -- but I dont know why it doesnt.
I tried copying D1 and paste special - formats on B1 but no luck. It will work if i just copy and paste but I have a whole sheet with this same problem so is there a way I can just format cell B1??
Any help would be much appreciated!