I am trying to rename the active sheet with 1st character of firstnam
and 1st character of lastname.
E.g. in cell K2, I have the staff name John A. Doe. I want the curren
active sheet to be rename to JD (i.e. the 1st character of first an
last name respectively.
Tried doing this but it didn't work:
ActiveSheet.Name=CONCATENATE(LEFT(LEFT(K2,FIND(
",K2)-1),1),LEFT(RIGHT(K2,LEN(K2)-FIND("*",SUBSTITUTE(K2,
","*",LEN(K2)-LEN(SUBSTITUTE(K2," ",""))))),1))
Always have error in the "FIND" function. Thanks in advance for you
hel
--
Message posted from
http://www.ExcelForum.com