View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson
 
Posts: n/a
Default 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