Question: how to copy an excel column without the formula?
Answer: Select the cells or ranges you wish to copy.
Select the “Home” tab.
Select “Copy” in the “Clipboard section.
Select the cell you wish to paste your values to.
Select the lower half of the large “Paste” button. From the extended menu that appears, select “Values“.
Select “OK“.