Excel removes parenthesis when editing formula

New Contributor



When I edit the formula below Excel removes the parenthesis {} & then the formula doesn't work.




If I add them in manually then it just changes the formatting to text. FYI-the formula totals up an assigned number (in a table) for each text value (in a table) within a data range.



2 Replies
best response confirmed by tima26hotmailcom (New Contributor)

@tima26hotmailcom Indeed. When you edit a formula that is enclosed in curly brackets you need to confirm it with Ctrl-Shift-Enter. The the curly brackets will be included again.