Hi
I have list of excel formula for matching A and B column.
the same formula required in Macro.
First Name Last Name Email pattern Excel fourmula Result
Abhishek Garg abhishek.garg =LOWER(A2&"."&B2) TRUE
Abhishek Garg a.garg =LOWER(LEFT(A2,1))&"."&LOWER(B2) TRUE
Abhishek Garg agarg =LOWER(LEFT(A2,1))&LOWER(B2) TRUE
Abhishek Garg abhishek =LOWER(A2) TRUE
Abhishek Garg garg =LOWER(B2) TRUE
Abhishek Garg gabhishek =LOWER(LEFT(B2,1))&LOWER(A2) TRUE
Abhishek Garg abhishek_garg =LOWER(A2)&"_"&LOWER(B2) TRUE
Abhishek Garg abhishekg =LOWER(A2)&LOWER(LEFT(B2,1)) TRUE
Abhishek Garg a_garg =LOWER(LEFT(A2,1))&"_"&LOWER(B2) TRUE
Abhishek Garg garg.a =LOWER(B2)&"."&LOWER(LEFT(A2,1)) TRUE
Abhishek Garg garg_a =LOWER(B2)&"_"&LOWER(LEFT(A2,1)) TRUE
Abhishek Garg garga =LOWER(B2)&LOWER(LEFT(A2,1)) TRUE
Abhishek Garg abhishekgarg =LOWER(A2)&LOWER(B2) TRUE
Abhishek Garg gargabhishek =LOWER(B2)&LOWER(A2) TRUE
Abhishek Garg garg_abhishek =LOWER(B2&"_"&2) TRUE
Thanks
Josh
Bookmarks