We have a spreadsheet with about a thousand email addresses. Is there a way to JUST have the first part of the email address, and delete the rest?
Not knowing what "first part" and "rest" means I will make a sugesstion.
Data>Text to Columns>Delimited by "something" then choose to skip the
column after "something".
Or used the "fixed width" option if that suits.
It starts at A2 assuming row 1 is header, change the cell reference to
suit, copy down...