Newsletter - October '09
|
|
Spreadsheet Tips
|
|
Replacing commas in email addresses.
|
 |
Spreadsheet Tips - Tidying a Mailing List (2 of 3)
|
In this second in the series of three tips to help you tidy your e-mailing lists,
we look at a quick but useful method to replace the most common typing error in
email addresses. Often when people fill in their email address, they type in a comma
rather than a full stop. For instance franc@workingdata,co.uk has a comma rather than a
full stop between 'workingdata' and 'co'. Using Excel's Find & Replace tool, we can tidy
these up quickly.
|
|
|
Replacing commas in email addresses
|
|
|
Let's take the example from the previous paragraph, franc@workingdata,co.uk and add
in one other, info@sales,com as in Fig 1.
|
|
|
|
 |
|
|
We go up to the Edit menu and select Replace. As you can see from Fig 2, we can also select this by
using the keyboard shortcut, CTRL+H, which means 'hold down the Ctrl button and press h'.
|
|
|
|
 |
|
|
This brings up the 'Find and Replace' dialog box. In the Find What field we enter a comma,
and in the Replace with field, we type a full stop, as in Fig 3.
|
|
|
|
 |
|
|
Finally, click the Replace All button and all the commas will be replaced with full
stops as in Fig 4.
|
|
|
|
 |
|
|
This quick tip could save you hours and hours of clicking and re-typing. There are many
more ways to greatly reduce the amount of time you have to spend getting your data working.
Now that your data is tidy, it is important to get the message through to your prospects.
Contact Kate Barlow at
Branchout Internet Marketing on 01608 737653 to discuss your e-marketing.
|
|
|
Next month we will look at setting up the salutation.
|
|
|
|
back to top |
|
|
|
|
