The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
Help with Excel Spreadsheet (Find and Replace)
powerss
Registered User regular
Registered User regular
Ok, so I have an excel spreadsheet with a bunch of email addresses in a colum and rows.
I want to find every address that ends in a .edu and delete that row.
How the hell do I do this?
Excel Mac, BTW - but I can access Excel for Windows.
I want to find every address that ends in a .edu and delete that row.
How the hell do I do this?
Excel Mac, BTW - but I can access Excel for Windows.
powerss on
0
Posts
Insert a new column to the right of the email addresses. In the first cell of that column, type
=RIGHT(A1,3) (where A1 is the first cell of the email address column). Select the entire column, and do Edit - Fill - Down to fill the entire column. Then select the whole spreadsheet and sort by the column you just created. All the "edu" addresses will be clumped together for easy deletion.
the "no true scotch man" fallacy.
When I do this it says it creates a circular reference.. I wonder what I'm doing wrong.
Holy crap you're god.
stout's Amazon Wishlist | my lastFM