Function to Combine Names and Middle Initital In Various Formats
Hi,
Am Thu, 13 Sep 2012 21:52:11 +0200 schrieb Claus Busch:
try:
=LOWER(IF(ISNUMBER(FIND(" ",A1)),LEFT(A1,LEN(A1)-2)&"."&RIGHT(A1,1)&"."&B1,A1&"."&B1)&" @xxx.c0m")
better and shorter:
=LOWER(SUBSTITUTE(A1," ",".")&"."&B1&" @xxx.c0m")
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|