Cell A displays:
Cell A formula:
Cell B is pure text of value:
Cell C formula: =ChkFile(CONCATENATE(B43,"\",A43))
ChkFile is a very simple macro.
This set of affairs works fine for cases of Cell A being plain text but this calculated value results in Cell C showing
Can anyone help please and if possible without using VBA?
Edit: I didn't originally want to supply the macro code as I didn't feel it was relevant but also .. I'm no VBA programmer so not sure if I'm breaking any golden standards even in a couple of lines!
Public Function ChkFile(Name As String) ChkFile = FileDateTime(Name) End Function