Concatenate is killing me...

[rhonllanders]

I have a formula that is not working, however, I cannot figure out why. All works perfectly until I add the ")" at the end. I need it to reflect the close bracket at the end. Can you please show me what I'm doing wrong with this formula?

=CONCATENATE("Current ",CHAR(10),"(",(TEXT($G$1,"Mmm YYYY"),")")))

 

[Fluff]

Hi & welcome to MrExcel.
How about

=CONCATENATE("Current ",CHAR(10),"(",TEXT($G$1,"Mmm YYYY"),")")

 

[rhonllanders]

You got it! Thank you! You saved me!

 

[Fluff]

You're welcome & thanks for the feedback.