Cell A1 = blank
Cell A2 is €¦
=CONCATENATE(RIGHT(YEAR(NOW()),2),TEXT(MONTH(NOW() ),€�00€�),TEXT(DAY(NOW()),€�00€�),TEXT(HOUR(NO W()),€�00€�),TEXT(MINUTE(NOW()),€�00€�),TEXT(S ECOND(NOW()),€�00€�))

(results in yymmddhhmmss)

I need a macro or something that when A1 = blank, then I want the resulting
value from A2 to be put into A1. I DO NOT want the formula copied from A2.

What do I need to do to get the resulting value from A2 into A1?