Excel Expanding formulas in Formula Bar

[99DodgeRam]

When I write a formula referencing a table, Excel is placing a return character after each left bracket. This started about a week ago and I don't know what event happened that changed the behavior. Happens consistently with any formula that references any table. I have to make the formula bar much larger than necessary to edit the formula.

 

[t0ny84]

When I write a formula referencing a table, Excel is placing a return character after each left bracket. This started about a week ago and I don't know what event happened that changed the behavior. Happens consistently with any formula that references any table. I have to make the formula bar much larger than necessary to edit the formula.

Hey 99DodgeRam,

Have you recently updated\installed any new addons to Excel or made any changes to the settings? If not something to try would be to do a repair of Excel and hopefully it will fix this.
Reset Microsoft Applications

t0ny84

 

[99DodgeRam]

My coworker figured it out....for whatever reason, I had a Carriage Return in the Column Header ergo the CR is returned in the formula.