1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Google Sheet Formulas to Excel

I have information that I recieve from Google sheets. I download it to excel. When I open in excel, all the formulas break and I get the #NAME? thing in all the cells. All the formulas are fine but for some reason Google sheets adds {} to the formulas. So i have formulas that look like this: {=xlookup(A1,A:A,B:B)}. if I click into the cell to edit, and then just click enter, the {} go away and the formula works fine. However, there are a ton of formulas and it doesnt make sense to click through each one by one. I tried highlighting all and hitting F9 or ctrl-alt-F9 but that doesnt have any effect.

Anyone know a way to fix all the formulas at once?

submitted by /u/SauceHankRedemption
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#google sheets
#Excel alternatives for data analysis
#Excel compatibility
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#Google Sheets
#Excel
#formulas
#xlookup
##NAME?
#Excel formulas
#{} braces
#formula error
#downloading
#cells
#sheet compatibility
#Excel troubleshooting
#highlighting