Exactly how do I delete a space following an email address in Excel files?

Exactly how do I delete a space following an email address in Excel files?

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 eliminate any spaces from your file:

 

In Excel:

Highlight and copy the space that is after the email address.

Open the “Find and Replace” choice by clicking CTRL+F or by choosing Edit > Find > Replace.

Choose the Replace tab.

In the “Find” field, paste the space you copied earlier.

Leave the “Replace” field blank.

Click Replace All.

 

Using Notepad:

Highlight and copy the column of email addresses from your Excel file.

Open the Notepad program by selecting Start > All Programs > Accessories > Notepad. Composition the email addresses into Notepad.

Place the cursor immediately after the first email address on the list. Click and pull to the right to highlight any space. Copy the area you just highlighted.

Click CTRL-H to open the “Replace” box. Paste the space you duplicated into the “Find What” box. In the “Replace with” area, place your cursor inside and then click Replace All.

 

Leave a Reply

Your email address will not be published. Required fields are marked *