Hi all,

I have a spreadsheet where I have the date/time in a cell. I want to extract the date, and I have done it with the function =LEFT($A2,10)

However, I need to copy this into approximately 140,000 cells to get what I need. Is there an easy way to paste it into all the cells (obviously changing the reference cell as I go down), without the drag method, and having to wait for 140,000 lines to scroll by?

Thanks so much in advance!