Duplicating cell entries

In B1 write formula:

Formula:

Please Login or Register  to view this content.

and copy it down

Later on copy all column B, and paste special as values

Hi,

Let's discuss here (then somebody else could also benefit from it).

1) make sure cell has general format (Ctrl+1) numbers tab, General
2) enter the formula
3) copy it down as needed. for instance, if you have 200 values in column A, select cell B1 (with formula): Press Ctrl+C, Press Ctrl+G and write B1:B1200 and press OK. Press Ctrl+V
4) Copy whole this range B1:B1200 (It shall be still selected. If not select it manyally or with Ctrl+G as above) and press Ctrl+C
5) Paste special as values (press Ctrl+Alt+V and select values)

in B1:B1200 you shall have values now, so you can delete or clear contents of column A