benchmark email logo
Contact Our Sales Team:
800.430.4095 or Live Chat
or Email Marketing Free Trial

Frequently Asked Questions

Search through more than 1,000 answers

 
Search for topic


How do I delete a space after an email address in Excel file?
Sometimes email addresses are entered into a Microsoft Excel file with spaces after them and this can cause issues when you try to upload the list into your Benchmark Email account. Follow these steps to remove any spaces from your file:

In Excel:
  1. Highlight and copy the space that is after the email address.
  2. Open the "Find and Replace" menu by clicking CTRL+F or by selecting Edit > Find > Replace.
  3. Select the Replace tab.
  4. In the "Find" field, paste the space you copied earlier.
  5. Leave the "Replace" field blank.
  6. Click Replace All.
Using Notepad:
  1. Highlight and copy the column of email addresses from your Excel file.
  2. Open the Notepad program by selecting Start > All Programs > Accessories > Notepad. Paste the email addresses into Notepad.
  3. Place the cursor after the first email address on the list. Click and drag to the right to highlight any space. Copy the area you just highlighted.
  4. Click CTRL-H to open the "Replace" box. Paste the space you copied into the "Find What" box. In the "Replace with" section, place your cursor inside and then click Replace All.
Was this FAQ helpful?



Email Marketing Trial Sign up for our free Email Marketing trial today!



We are here to help!
Our Customer Support Team is standing by to answer your questions.
Call 800.430.4095
Live Chat Support
Knowledge Base
Find instant answers to Frequently Asked Questions
   
Free Live Webinars
Email experts present the ins and outs of email marketing during these free online seminars.
   
Video Tutorials
Quickly and easily learn how to use Benchmark Email with step by step video tutorials.
Corporate Headquarters
Benchmark Email
10621 Calle Lee, Building 141
Los Alamitos, CA 90720, USA
Phone: 800.430.4095
Fax: 562.314.3065