auto delete characters in cell left of @ sign
Select the range
edit|replace
what: @*
with: (leave blank)
replace all
Rusty wrote:
I have a spreadsheet with about 1000 email addresses. All I want from those
email addresses is the domain name. Can anyone tell me a quick way to
automatically delete all the text to the left of the @ sign in the email
address? I can do it manually, but that's awfully boring not to mention time
consuming.
Thanks.
--
Dave Peterson
|