Help converting basic Excel Formula

[ABHalpain]

I know this is probably an overly simple code that is escaping me this morning but how would I write this in designer ="76C"&Right([Year],2) Expected output would be something like 76C22

I tried  ="76C"&&Right([Year],2)  and '76C'&&Right([Year],2) Both came back with no results

Thank you!!

[SPetrie · Accepted solution]

Assuming that [Year] is formatted as text you would use +

"76C"+Right([Year],2)