triadacentral.blogg.se - Excel clean email column

#EXCEL CLEAN EMAIL COLUMN SOFTWARE#
#EXCEL CLEAN EMAIL COLUMN CODE#
#EXCEL CLEAN EMAIL COLUMN PLUS#

#EXCEL CLEAN EMAIL COLUMN CODE#

There is a reason why you should only use the postal code for this sorting and not the place: in some cases, different place names can be used for the same postal code. And we are doing this first by postal code, then by address and then by the last name. To check for doubles, we are first going to sort the Excel sheet with mailing addresses.

#EXCEL CLEAN EMAIL COLUMN PLUS#

Especially if you are mailing physical pieces: there is the production cost, plus postage cost. After that, first the message (“”, which is an empty string) is shown when the condition is true, the second message (“CHANGED!”) is shown when the condition is false.Ī very costly error in mailing lists is double entries. The ‘IF’ argument indicates that we want to check a certain condition: if cells B2 and C2 are exact the same, including the case. There is also an easy way to check it, via the following formula, where the original values are in the B-column and the ‘proper’ values in column C: =IF(EXACT(B2 C2) ”” ”CHANGED!”) The formula consists of different parts. If the formula above made changes, you probably want to know which names have changed, so that you can also correct them in your database, your CRM system. In these cases, manually checking it wouldn’t be a bad idea. E.g., the last name of the queen of Belgium is d’Udekem d’Acoz. And certainly the ones with a lowercase ‘d’ are sensitive to it: they are usually a sign of nobility. In the region where I live, some last names have a lowercase d (d’, de or du) or a lowercase v (van or von). And you need to be careful, especially in some parts of the world. Using this function in Excel is, of course, a ‘quick and dirty’ way of doing this. And then you extend that formula to the rest of the column (you can do that by grabbing the ‘+’ sign at the right bottom border of the cell and dragging that to the last cell you need). Suppose all the names are in the B column, with B1 being the column title, you go to cell C2 and use the following formula: =PROPER(B2). If you have a mailing list exported to Excel, you can easily transform a column with names. So ‘proper’ would transform EDDY HAGEN into Eddy Hagen. ‘Upper’ will transform all the letters into uppercase, ‘lower’ into lowercase and ‘proper’ will give every word a first capital letter. Well, Excel has the following functions: UPPER, LOWER, PROPER. Let’s start with an easy one: how can you – automatically – adjust the use of uppercase/lowercase in Microsoft Excel. They could, and should, have been prevented from happening. And all of these mistakes are very annoying. And the same company often shouts at me in their emailings: ‘EDDY, now is the right time!’. And one brochure was addressed to miss Eddy Hagen (I checked it before starting writing this blog post and I’m definitely male! ? ). And I got a ‘last chance’ invitation for a seminar that I already had attended a few weeks ago… And if I look a bit further back, I’ve received two pieces of the same mailer, on several occasions.

#EXCEL CLEAN EMAIL COLUMN SOFTWARE#

I got one for a very special promotion for a software upgrade, which I had already purchased from their website about a month ago. Just to give you an idea how often I see errors in mailing lists: the past week I got a mailing in the wrong language (in French instead of Dutch).

For some common errors in mailing lists, a few simple tricks in Microsoft Excel can already help you. Two mailing pieces at the same moment, wrong use of capitals, wrong language, even assigning me the wrong gender. And I know: I see them on a regular basis. And it’s definitely reflecting on the brand image of the sender: errors in mailing lists.

Especially when you are on the receiving side.