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 want to add or remove …

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 entered into.

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 individual cells as …

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 erroneous formula …

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 but remove the …

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 the use of …

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 Excel version (s) & …

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 (periods) Many …