Excel Expanding formulas in Formula Bar

99DodgeRam

New Member
Joined
Oct 29, 2020
Messages
2
Office Version
  1. 365
Platform
  1. Windows
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.
 

Attachments

  • Screenshot 2020-10-29 144108.jpg
    Screenshot 2020-10-29 144108.jpg
    9.3 KB · Views: 4

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

t0ny84

Board Regular
Joined
Jul 6, 2020
Messages
141
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
  2. Mobile
  3. Web
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

New Member
Joined
Oct 29, 2020
Messages
2
Office Version
  1. 365
Platform
  1. Windows
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.
 

Forum statistics

Threads
1,148,154
Messages
5,745,097
Members
423,922
Latest member
Taconumber

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top