To do this with formula:
1.) In a completely blank column, enter the following formula in the top cell (e.g., B1):
This will fill the array.
2.) Click the letter at the top of the output column to select the entire column.
Ctrl-C to copy the entire contents of that column to clipboard.
4.) Click the
A at the top of Column A to select the entire original column.
Ctrl-Alt-V ("Paste Special"). A small clipboard icon will appear lower right of the visible screen area. Click it and choose
Paste values only.
6.) Click the letter at the top of the formula column to select that entire column again and then click the
Delete key to delete the formula and its results from that column, returning it to its original blank state.
The entire process should take about 10 seconds.