Substitute+concantenate formula adding character when saving

[Seth_Berman]

have gone back to work on an app i havent touched since early 2020 and noticed that this formula:

SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(CONCATENATE(RIGHT([client],4),NOW()),"/",""),":","")," “,”") is doing something odd when saving to the google sheet. it is producing an extra character, an apostrophe at the beginning of the string. It did not do this before and i was wondering if something had changed.

when I look at the google sheet i don’t see the apostrophe until I click in the cell and look at the formula bar. '639602242021161947.