Feb 14, 2005 · Can some please tell me how I can delete/remove an array formula. I received a file that has an array. I need to delete the array, but when I do I get...

Jul 12, 2012 · Using excel 2007 Isnt there a short cut to add and remove the dollar sign from formulas? I know I can go into an indiviual cell and highlight whatever part of the formula i …

Oct 17, 2002 · You're tryiung to delete part of a formula that's been entered (as an array formula) into multiple cells at the same time. You need to delete the formula from all the cells it was …

Apr 4, 2008 · I haven't been able to edit the default formula, but it is possible to change it by deleting all cells in the row or column, then entering a new formula. You can then change …

Jun 9, 2015 · Removing "FALSE" result from IF Function itsmekarak Jun 9, 2015 false formula problems file attached if formula I

Jul 8, 2012 · My office is using Excel 365 in Windows 10 I ran the below lines of code, then the "@" sign is showing up as part of the formulas on the excel spreadsheet, and causing …

May 18, 2009 · Sounds like maybe you're trying to create a formula to alter a formula. Are you expecting to change the formula in E15 and then have the formula in F15 change with that cell …

Jun 19, 2014 · Removing formulas from Excel sheet with multiple tabs. Can you do the equivalent of 'Copy Paste Special Values' to remove the formulas from Multiple tabs in one go, without …

Jun 13, 2014 · What version of Excel are you using? I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what …

Mar 20, 2006 · Hi i have a list of addresses in column A Can you give me a formula for column B that will duplicate what is in the corresponding cell in column A but removing any full stops …