In A column, i have people names like this :
i need them changed/formatted like this in B column :
Nb. letter in bold is in capital case, even the source is in lower case
how to do that, please help guys, GBU for answering
Code:
john
i need them changed/formatted like this in B column :
Code:
name "john":
{
email((age)zip.[B]J[/B],0,0,0);
email((age)zip.[B]J[/B],0,2,0);
email((age)zip.[B]O[/B],0,0,0);
email((age)zip.[B]O[/B],0,2,0);
email((age)zip.[B]H[/B],0,0,0);
email((age)zip.[B]H[/B],0,2,0);
email((age)zip.[B]N[/B],0,0,0);
email((age)zip.[B]N[/B],0,2,0);
break;
}
Nb. letter in bold is in capital case, even the source is in lower case
how to do that, please help guys, GBU for answering
Last edited: