Make A column, to be like this in B column. Not easy, but not too hard either

[basketmen]

In A column, i have people names like this :

john

i need them changed/formatted like this in B column :

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

 

[Gerald Higgins]

Questions:

1) Do you want all of that data in column B in a single cell ? Or across multiple cells ?
2) Can you show us what you would want to do with a name of a different length or format ?
For example, CHRISTOPHER
For example, JOHN PAUL

 

[basketmen]

Questions:

1) Do you want all of that data in column B in a single cell ? Or across multiple cells ?
2) Can you show us what you would want to do with a name of a different length or format ?
For example, CHRISTOPHER
For example, JOHN PAUL

thank you for the reply

1) its no problem single or multiple cells, which is easier

2) dont worry, its only easy people last name, no space at all, the source in A column are in lowercase, like
john
michael

its need to be uppercase in the B column like in bold in first post

 

[Gerald Higgins]

OK. Just to be absolutely clear, let's ask part of question 2 again.
2) Can you show us what you would want to do with a name of a different length or format ?
For example, "michael"

 

[basketmen]

OK. Just to be absolutely clear, let's ask part of question 2 again.
2) Can you show us what you would want to do with a name of a different length or format ?
For example, "michael"

it will be like this

name "michael":
{
email((age)zip.[B]M[/B],0,0,0);
email((age)zip.[B]M[/B],0,2,0);
email((age)zip.[B]I[/B],0,0,0);
email((age)zip.[B]I[/B],0,2,0);
email((age)zip.[B]C[/B],0,0,0);
email((age)zip.[B]C[/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]A[/B],0,0,0);
email((age)zip.[B]A[/B],0,2,0);
email((age)zip.[B]E[/B],0,0,0);
email((age)zip.[B]E[/B],0,2,0);
email((age)zip.[B]L[/B],0,0,0);
email((age)zip.[B]L[/B],0,2,0);
break;
}

 

[basketmen]

upp please help guys, its should be not too hard, just the easy code