Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to extract anitials from an email adresse?
Hi,
i need some help extracting initials from email adresses. All adresses have the same domain name @qwertyui.dk but they have different lengths of initals, e.g. aa or aab or aabb, but no more than 4 characters. Hope you can help Martin. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to extract anitials from an email adresse?
If I understand your question correctly, you want the dk part of the
@qwetyui.dk entry. This should do that for you... =TRIM(RIGHT(SUBSTITUTE(A1,".",REPT(" ",99)),99)) -- Rick (MVP - Excel) "Tippo22" wrote in message ... Hi, i need some help extracting initials from email adresses. All adresses have the same domain name @qwertyui.dk but they have different lengths of initals, e.g. aa or aab or aabb, but no more than 4 characters. Hope you can help Martin. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to extract anitials from an email adresse?
Hi Martin
With the email adress in A1 try this formula in B1: =LEFT(A1;FIND("@";A1;1)-1) Regards, Per "Tippo22" skrev i meddelelsen ... Hi, i need some help extracting initials from email adresses. All adresses have the same domain name @qwertyui.dk but they have different lengths of initals, e.g. aa or aab or aabb, but no more than 4 characters. Hope you can help Martin. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to extract anitials from an email adresse?
Hi,
When you say 'initials' I assume you mean the bit to the left of the @ If so try this. Alt+F11 to open VB editor Right click 'This Workbook' and paste the code below in on the right call with =GetName(A1) where A1 contains an Email address Function GetName(HyperlinkCell As Range) GetName = Replace(HyperlinkCell.Hyperlinks(1).Address, "mailto:", "") GetName = Left(GetName, InStr(GetName, "@") - 1) End Function Mike "Tippo22" wrote: Hi, i need some help extracting initials from email adresses. All adresses have the same domain name @qwertyui.dk but they have different lengths of initals, e.g. aa or aab or aabb, but no more than 4 characters. Hope you can help Martin. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to extract anitials from an email adresse?
Tusind tak, var lige hvad jeg skulle bruge!
"Per Jessen" skrev: Hi Martin With the email adress in A1 try this formula in B1: =LEFT(A1;FIND("@";A1;1)-1) Regards, Per "Tippo22" skrev i meddelelsen ... Hi, i need some help extracting initials from email adresses. All adresses have the same domain name @qwertyui.dk but they have different lengths of initals, e.g. aa or aab or aabb, but no more than 4 characters. Hope you can help Martin. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract domain names from email IDs | Excel Worksheet Functions | |||
Using Advanced Filter to extract email addresses | Excel Discussion (Misc queries) | |||
How to extract email address in hyperlink | Excel Worksheet Functions | |||
Extract email addresses | Excel Worksheet Functions | |||
How can I extract automat. the email from a list of hiperlinks? | Excel Discussion (Misc queries) |