How can I split a column in half?

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

Post Flair (click to view more posts with a particular flair)

unsolved

Post Body

Hey, I have a very lengthy list of emails that is numbered of about 800. The column is titled "email" at the top. I need to split the "email" column into two so that neither one can be more than 501 rows. I'd be fine even splitting the column to be 501 and then 299. I'm not sure how to do this without manually selecting all the cells past row 501 and pasting it in a new column. I’m asking this since i’ll have to do this with potentially 100s of excel files over the years so it’s not practical to do it “manually”. Any help on this would be greatly appreciated, thanks!

Author

Account Strength

100%

Account Age

3 years

Verified Email

Yes

Verified Flair

Total Karma

15,093

Link Karma

7,214

Comment Karma

7,859

Profile updated: 1 week ago

Posts updated: 10 months ago

comfybonfire

Subreddit

r/excel

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 1 year ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/excel/comme...