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.
|