I need a dictionary formula for one of my imports. I have a column that is either blank or will have some data in it. If it has any sort of data in a cell, I need to add today's date. If it is blank, I need it to stay blank.
Is this possible? Any help would be appreciated!
Sorry for the delay in replying but that regular expression worked perfectly so many thanks for that. What I have been thinking, which would be even better would be if there was an expression for example:
'If the is any form of data in column A, to give the date which is in column B'..?