Get in Touch

  • Live Chat
  • Email Us
Call Us
  • INTL 001.562.252.3789
  • USA 800.430.4095
  • UK (+44) 20 3695 2266
  • Switzerland (+41) 43 508 4676

Frequently Asked Questions

was designed with your needs in mind. So, there is a good chance that you will find the answer to your question here. Plus, it is available to you 24 hours a day, 7 days a week.

Select a topic to start

Search by Topic

Search by Keyword

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? print up down

More related questions