View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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.