HELP - Unable To Remove Array Formula

[woodpecker2]

I've set up an Array formula but now I'm unable to delete it! I've tried amending, deleteing and copying one cell from another over it but all I get is a warning message telling me the cell is part of an Array.

Can anyone advise how I can remove it?

 

[Richard Schollar]

Select the whole array (ie all the cells that contain the array formula - it must be more than 1) - hit F2 and use Ctrl+Return to enter. This will convert the array to normal formulas and now you can delete/amend them individually.